Totals at rolled up level

Options
pallavi6.gupta
pallavi6.gupta Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor
in Planning & Modeling

Hi,

We have applied some filters on the basis of which we want the data to be published on the dashboards. The data is correctly being picked up as stated in the filters, however at the total level(level at which data is getting rolled up) the totals are coming incorrect , it picks totals of the entire e.g. region/category instead of picking up totals of the filtered items.

Eg. if SKU1 = 15 ;  SKU 2 =10 (both roll up to category 1)

On applying filter i want only SKU 1 i.e. 15 , then at total it should show only 15 rather than 25.

 

Thanks 

Tagged:

Comments

  • pallavi6.gupta
    pallavi6.gupta Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor

    Hi Rob,

    Thanks for your solution, we tested and it is working however there are few concerns:

    1. We will have to create 2 line items for every line item that has data (one for import and one for domestic)

    2. Each line item is taking a cell count of 11 million

    Is there any other optimized solution?

     

    Regards,

    Pallavi

Categories