Sorting in Pivot table

[alanwong1178]

Hi all,

I would like to do some sorting on Pivot table with multiple layer or dimension. In the case below , I would like the pivot table to be sort by Client level first (yellow). 

In this sort  by sales in descending order from Client A , Client B then Client C.

Then I would like to sort by Sales in Country level within each client. In client B case, I hope that it can US , Taiwan then Japan

Then I would like to sort by Sales in Product level within each country in each client. For example , I hope that it can be sort as Software , Alcohol then Jewelry under US for Client C.

Please kindly help

[Or]

If you select "Sort by first measure", I think this is exactly what should happen...

[alanwong1178]

Actually I would like to make it more dynamic because I have multiple measures /column like cost , profit. This means it can sort by profit or other measures which means it is not necessary to be first measures only

[Or]

Unfortunately, you can only sort by the first measure. The only way to make this dynamic is to make the measures themselves dynamic, so that the user can select which measure comes first.