05-16-2018 07:56 PM
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.
05-17-2018 01:17 AM
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.