1 of 1 people found this helpful
This can be done by creating a string parameter that lists out all the measures. Then, use this parameter in a calculation similar to the following:
case [Choose Your Measure Parameter]
when 'Sales' then sum(Sales)
when 'Profit' then sum(Profit)
when 'Discount' then avg(Discount)
Then, place the dimension on the filter shelf and select the Top tab. Select By Field: and choose the above calculation from the drop down menu list. Click OK. Then, right click on the parameter and select Show Parameter Control.
Hope this helps!
This is really helpful but still there is a question.
So now I am able to filter the table on the basis of Measures. But is it possible to create something like parameter or filter for Top 10 highest and Top 10 lowest.
For example – Suppose User filtered the table on one of the Measure by selecting from the Parameter. Now he want to see the Top 10 highest or Top 10 lowest. SO is it possible to give any Parameter or filter, from there user can filter the Top 10 highest and Top 10 lowest
First, place the calculation from the above post on the view and sort the dimension in the desired order. Then, to get the top/bottom another parameter and calculated field should be created. Create a string parameter (i.e. Top or Bottom 10) and create a list with Top, Bottom.
Then, create a calculated field using this parameter similar to the following:
case [Top or Bottom 10]
when 'Top' then index()<=10
when 'Bottom' then last()<=9
Place the above calculation on the filter shelf and check True. (Make sure that the calculation is being computed in the correct way, i.e. Table down). Then, show the parameter control.
Hope this helps!