Pivot table- Rank

[Anonymous]

Hi,

I have a pivot table and I have sorted it according to the total points(descending).

Expression for total points is attached. I've used the same expression to sort the table.

I  want to add a rank to the teams depending on the total points (highest point will be rank 1). How can I achieve that? I want the rank function to work even when the table is expanded.

Thanks!

[everest226]

Rank( Count (DISTINCT

Just a thought , use this in expression.

[Clever_Anjos]

Maybe

Rank( Sum(total <Team>  [your points expression]))