rank sorting..

[#1]

Hello Experts,

I need your valuable help here...

How do i apply the sort on Rank...Please find the image below..

Thanks in advance..

Thanks & Regards,

Venkat T

[#2]

Hi

in the sort tab

use the rank expression tab in the

expression

[#3]

Thanks for your  reply. but that didnt work out, the sorting what  we are seeing in the image is already included with this option.

Thanks & Regards,

Venkat T

[Gysbert_Wassenaar]

Sort Program Grp by Y-Value. That will sort the pivot chart on the first expression in the chart which in your case is the Rank column.

[#5]

Hello Gysbert,

thank you so much for your help...your suggession works perfect for this sorting issue....but when i use this option...the basic  feature of Pivot i.e master detail is turned off...

Please help me to solve this issue..

Thanks & Regards,

Venkat T