Jul 19, 2020
Pivot table not sorting by ASC order by Week name. Requesting help with sort.
I'm trying to sort the line chart by Week 1 through Week 52.
As you can see by the image, the Order by Ascending order doesn't seem to work with my data.
Perhaps I have the Rows and Columns data mixed up.
Can someone help sort by Week 1 thru 52?
Thanks!!
Link
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
Hi, Steven,
Text data does not sort the same as numeric data. So what you are experiencing is not a bug.
Text data needs to be structure in a particular way for sorting to work correctly.
For example, if you are sorting number up to 2 numbers then the following will not work
"1"
"2"
"10"
It needs to be padded, if you know what I mean.
"01"
"02"
"10"
See my example below to demonstrate what happens
Hopefully, this will help you underestand what is needed for text data to sort correctly.
I hope this answeres your question.
Ben Liebrand
Original Poster Steven Bae marked this as an answer
All Replies (3)
Hi, Steven,
Text data does not sort the same as numeric data. So what you are experiencing is not a bug.
Text data needs to be structure in a particular way for sorting to work correctly.
For example, if you are sorting number up to 2 numbers then the following will not work
"1"
"2"
"10"
It needs to be padded, if you know what I mean.
"01"
"02"
"10"
See my example below to demonstrate what happens
Hopefully, this will help you underestand what is needed for text data to sort correctly.
I hope this answeres your question.
Ben Liebrand
Original Poster Steven Bae marked this as an answer
Jul 20, 2020
Hi, Steven,
You are welcome and thank you for your feedback.
I'm glad I was able to help.
You have learnt something new :)
Ben Liebrand