Sorting

[sureshmaddipati]

I have region field as dimension i would like to sort it based highest value we have hierarchy in place under region country and entities 

[Anil_Babu_Samineni]

Perhaps try this with sort expression in descending order.

Aggr(Rank(Sum(Value)), (Region, (Text, DESCENDING)))