Sorting the selected dimension

[sureshmaddipati]

Hi ,

I have two dimesion  and we have used secondary dimensionality in measure to create a pivot table as shown

now based on selecting any dimension user wants the measure to be sorted in descending order please se the measure below.

 we have used dimensionality concept in our expression as shown below

Please let me know how to sort all measures if we select any one  dimension

thanks,

Suresh 

[jchx]

Are all your measures sorted by descending numerically?

[sureshmaddipati]

No as I don't find option to sort measure 

[sureshmaddipati]

 I am using pivot table