Ranks based upon Selected Measure

I have come across one interesting Business Requirement, what that is "Customer want to see the Top 5 States based up on the selected Measure".

For this requirement, i have provided the following steps.


1) Create a parameter like below.

2) create a calculation, drop it on "Text Labels"

3) Right click on parameter, then click on "Show Parameter Control".

4) Drag "Measure Selection" field twice onto Columns shelf, State on to rows shelf.

5) Then Right click on first Measure Selection Column (Rank) then click on "Discrete", Change ir from Column shelf to Row shelf.

6) Then applying the Sorting

7) Then Copy the Rank Column into "Filter Shelf". ( I am using laptop so how i am doing here is CTRL+ALT+Right click on Mouse + dragging into Filters shelf.)

8) Then Apply the Filter on Ranking

9) If you want to hide the Ranks, right click on rank field, click on "Show Header".

=====

I have added normal report, top5 City report ti the Dashboard to come to know how our calculation will work.

Measure