1 Reply Latest reply on Sep 7, 2013 11:54 PM by Shawn Wallwork

    How do I create a single filter on a worksheet using multiple sets?

    Hanson Gong

      Hi all,


      I have 3 different scenarios that project into the future. In the workbook view, I have the historical data combined with projected views using an area graph. When nothing is filtered, all 3 projection scenarios are aggregated. At the moment, the quick filter on the projection scenario dimension (which includes historic, projection 1, projection 2, and projection 3) requires me to manually select projection 1 and deselect projection 2 and projection 3.


      I have created 3 sets (historic + projection 1, historic + projection 2, historic + projection 3) to filter for one scenario at a time in order to avoid the aggregated scenario. Is there any way to create a single filter using the 3 sets?


      Thanks in advance,