I'm try a dynamic button that lets you view the graphs I've developed through two EUR / USD filters.
However I have two columns, one with the value in EUR and another and USD. But I want the graphics to show SUM according to the currency I choose.
For this I did:
- Create the custom category to drive the button bar
- Create the parameter to hold the button bar's selection
- Create the calculated data item that will hold the selected measure's value
- Add report objects and assign roles
I followed this tutorial https://blogs.sas.com/content/sgf/2016/04/27/use-parameters-to-pick-your-metric-in-visual-analytics-...
But the problem is that through this implementation I can not use the button bar in the report or section prompt area.
Has anyone had this? Do you have another implementation? Any tips?