How to group multiple measure in to one for search view

[don21]

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..

[FredrikE]

Hi!

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 🙂

//Fredrik