7 Replies Latest reply: Dec 1, 2016 10:00 AM by nayan lalla RSS

    Set Analysis showing all values but Dimension to only show selection

    nayan lalla



      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.


      Kind regards