Forum Discussion

maurcoll's avatar
maurcoll
Helper IV
2 years ago

Ranking in a table visual using a measure

Good Morning

I have a table that i need to rank based on the measure for % of sales

Store% of Sales

A

21%
B15%
C35%
D25%
E6%

 

The % is calculated as a measure dividing store sales by the total sales

I want to be able to add a column into the above table to show ranking for each store or a row number. I also need to be able to show the ranking if the number of stores changes. for example i have stores A - C filtered i want to see the ranking for just these 3 stores. In my data i sort the table by % highest to lowest.