Sorting Order for Pivot Table
I am trying to sort my pivot table by age ranges. I have a helper column that ranks the age with a number, since the age ranges are text strings. My pivot source is a Report that is sorted by the rank. When I run the pivot on the report, my age ranges do not sort in order
Like this:
Age Bracket Sort Rank
0-4 Days 1
5-9 Days 2
10-14 Days 3
When I run the pivot, I get this, where 5-9 is out of order
I have 23 locations in this pivot, so I can't repeatedly re-order these manually. Is there any way to make the correct sort order permanent?
Thanks
Answers
-
Hi @AFlint
You would need to have a 0 in front of the 5 for it to be seen as 5 and not "larger than something that begins with 3". Ex: "05-9 Days"
You could use Find and Replace to update every instance of this value in your source sheet(s) with 05-09, if that helps.
An alternative would be to create a Report out of this Pivot destination sheet as well.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
So the helper column is pretty much not needed? The Pivot is going to ignore the sort order of the source report? I believe you had posted in another discussion that the report sort was what was the driver
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives