Totals at rolled up level
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.