One way to do this is by creating a parameter and connect it to a text input box.
Then create a calculated measure that checks the value of the parameter and then chose the corresponding kpi, ie:
if [parameter] = 'kpi1' then kpi1
else if [parameter] = 'kpi2' then kpi2
Then use this calculated measute in your cross-tab
One problem is that you can't change the format dynamically depending on the chosen kpi, they all get what you specify for the calculated measure.
Another is that the user must type the exact name of the kpi. One way to solve this is that the text box filters a list with your kpi's and the user selects kpi from this list, also you create another parameter used in the calculated measure.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.