I'm running SAS Visual Analytics 8.2.
I would like to do the following:
Create a button bar with several categories
Based on the selection in this button bar, change the "Rows" Data Role in a crosstab.
For example, imagine a button bar with two options, "State" and "City".
If the user selects "State" then the table would look like this:
If the user selects "City", then the table look like this:
So, basically, the row aggregation has changed based on the selection in the button bar.
which shows how to select a measure based on user input, but I can't work out how to select a row.
Let me know if I can make the above clearer.
It should work the same as the example in the link.
Just change "selectedMeasureParameter" to "State" and "City" depending on the parameter.
Then use the calculated item on the rows role.