Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a pivot chart which is detached by default, and also I have few list boxes which allows to filter the chart. My question is how do I filter the detached chart when I select in list boxes. And if I click on chart, it should not filter.
if the answer is macro, how?
Thanks In Advance
You can use the Set Analysis to ignore the selections. For example, you have two filters "year" and "month" and you want "month" will be ignored, your expression in your chart will be:
sum({< month= >} Sales)
In Set Analysis, month= ignore all the selections on month.
Regards,