Forum Discussion
Top Three (Text)
Hello: I have a pivot table in my dashboard like this: * there are like 24 stores. store_name Share Of Sale Store 1 45.34% Store 2 41.45% Store 3 37.22% Store 4 35.62% ...
Hi samnaw
another option with measure would be this:
RANK | Rank of Item =
RANKX(
ALL(Dim_Product),
[Aggregation | Sum]
)After putting the table in the visual you can sort the column with 1,2,3
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.