I want to set up one chart with multiple expressions and dimensions in a pivot format that allows the contents to the chart to be dynamic.
I then want to be able to use buttons attached to macros to include or exclude a dimension or expression from the pivot.
E.g. If the dimensions Region, Salesperson, customer and expressions of sum(Sales) and sum(Units) were available, each of these 5 would have a button link to it.
If you activate the button then the item will appear in the pivot. This way if you wanted to see only Salesperson and Sales then pressing the salesperson and sales button would only include them in the chart and all other dimensions/expressions are not shown.
This would require the dimensions and expressions to be conditional but I haven't found a way to do it, if its even possible.
