Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 different charts on one report, for different purpose. If I filter something from filter-pane which is effecting both charts. But I do not want filter on first chart where as it should filter on second chart. Is this possible to exclude a chart(s) from filter pane.
Thanks,
Kranthi
Hi Kranti
This is possible, you will have to use set analysis. Below is a sample on how you can do this.
Just to explain what is happening with this expression Sum({1<Sales=>}Sales), Sum({$<Sales=>}Sales). So when you put 1 it ignores the selections and $ takes into account the selections.