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,
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,