Sort in pivot table

[tommyl]

Hello,

I have a graph like(1.jpg):

In this graph i am displaying countries according to the membership percentage. When i click on a continent in the map, the pivot changes but order by membership percentage changes. It turns out to be alphabetic as below(2.jpg):

I want to still display the countries in the pivot table in a descending membership percentage order. 

Summarize, if i select Asia, i want to display pivot as: 

Country	Membership %
Malaysia	74.03%
Iran	3.90%
HongKong	2.60%
Gaza	1.30%
Vietnam	1.30%

Could you please help me ?

Regards,

[Sameer9585]

May this works?

just turn off the all sorting setting in the properties . You will achieve yours.

Else please share the qvf if Possible.

[tommyl]

Hello, 

Thanks for your reply. I tried this but nothing has changed. Again, when i select a continent in the map, countries in the table comes in an alphabetic order.  

Regards,

[JordyWegman]

Hi Tommy,

You can sort on measure in a dimension. So what you have to do is copy your measure and put this in the Fx() for you dimension sort. Properties -> Sort -> Dimension -> Based on measure.

Jordy

Climber