How to sort in Pivot Table

[#1]

Hi All, In my pivot table I would like to sort for top five values.How to proceed please let me know the same

Thanks & Regards

Jai

[#2]

hi

check y-value descending on the sort tab

Peter

[#3]

Hi Jai,

You can try this dynamic pivot table sorting. please see the attached sample QVW document.

Thanks,

Saran.

[#4]

Hi,

Thanks for your kind reply.But thing is I want to show only 'TOP FIVE' values in my table.Let me know the same