SAS Visual Analytics 8.2: Selecting crosstab row data role based on user input

[MikeFranz]

Hi,

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:

State Cost

NC 100

TX 200

MN 150

If the user selects "City", then the table look like this:

City Cost

Charlotte 40

Raleigh 140

Dallas 200

Memphis 150

So, basically, the row aggregation has changed based on the selection in the button bar.

I found this link: https://blogs.sas.com/content/sgf/2016/04/27/use-parameters-to-pick-your-metric-in-visual-analytics-...

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.

Thanks,

Mike

[FredrikE]

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.

//Fredrik