BookmarkSubscribeRSS Feed
Quartz | Level 8

Dear all,


My data has many KPIs (56 to be exact). I have a requirement that I need to create a search box where if I type the name of KPI the corresponding cross tab must display that column data.

kindly let me know how can I achieve this..


Many thanks..





Rhodochrosite | Level 12


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.


Hope this can give you some inspiration 🙂





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. 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 2 in conversation