• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to sort 'Values' in a Pivot?

Karthik

New Member
Hi,


I've pivoted a list of states and their corresponding city population. So, the pivot has 'States' in the 'Row Labels,' and 'Population' as one of the 'Values' columns. Now, every time I open the pivot, it has refresh and sort the list of States to show only the top 5 or top 10 states by population.


How do we do this? I understand we can sort the 'Values' columns manually, but how do we set this is a default option, so every time the pivot is refreshed it shows only the top X states.


Best,
 
Hey Srinidhi,


I understand this option of applying the 'Top Ten' filters is available in Pivot. But, my specific question is, is it possible to have this set by default? Everytime I refresh the pivot, it should show me only the top ten states by population. Any clue?
 
Back
Top