1 Reply Latest reply on Apr 18, 2017 5:01 PM by Matt Lutton

    How do I compare filtered results to everything else?

    bob.jones.5

      In the sample workbook, what I'd like to see is one row for each measure then two columns -- the first column would show the total for the filtered items and the other column would show the total for everything else.

       

      I attempted to use a set, but there doesn't seem to be a way to dynamically change the contents of the set.  I also tried parameters, but as far as i know you can only select one item per parameter and I need the ability to select multiple items.

       

      Any other ideas?