Conditionally open charts based on selection of expression in a pivot chart
Hi All,
I have a scenario, in which I am using a pivot table. There are 3 dimensions and 2 expressions. The requirement is that when I click on a value of 1st expression (Exp A), it should open a chart (Chart 1).
And when I click on a value of 2nd expression (Exp B), it should open a different chart (Chart 2).
Have any of you come across such a scenario? If yes, what is the best possible way to handle it?