Set Analysis showing all values but Dimension to only show selection
I have an expression in a pivot table showing all values, no matter the "brand" selection. However if I do make a selection, I want only the field selected to show, however still keeping the total value.
Attached herewith is a sample of a Sales QV Model and related data in excel format.
In this model, I have sales of brands through 3 different channels. Each branch is part of a category.
So in my model, when i select "apple" , the pivot table should only show "apple" and not all other brands.
Please can you assist.
Please note the total sales should be 33923 and if i select fruit under category and it changes to 14190, that is still fine.