See ATTACHED if this helps.
Create a inline table with those 3 fields ( and use that field in your expression and you can keep a list box/multi box on top of your pivot table.
test.qvw 153.2 K
Using the grouped expression function is there a way to dynamically update my variance column to subtract the two columns. In other words, if I select actual in one column and budget in the next it should calc the variance between the two, but if I change actual to forecast it should update the variance. Seems like there should be a way to name your grouped expression.
You can can load the inline table.
Make three different table using the three expression.
And put the condition in chart that it will show only one chart at a time other two charts are invisible.
when u select the value from the list box accordingly the corresponding chart gets visible.
Hope this helps !