14 Replies Latest reply: Mar 7, 2018 10:52 AM by Matrika Dikshit RSS

    Excluding a filter from a particular chart

    Matrika Dikshit

      Hi,

       

      I am creating a sheet where I have two charts, I want to apply all filters on one chart but all except one on the other.  could you please help me with the best way to do it? I tried using set analysis, something like -


      =Sum({<[Reporting Customer]=>}[Gross Sales])  This works well for such cases, but does not work for chart where I do not have an aggregation such as in a histogram, or in cases where I use a calculated field such as % contribution where I basically do sum(sales for a particular customer)/sum (Net sales).

       

      Is there a better way than using set analysis, I tried alternate state, but that wont allow me to apply all except one, I am only able to assign one state to one chart.


      Any suggestions are much appreciated!