|
Pivot table sort order
Hello:
I have a pivot table which is sort by week number 1-52. How can I show the order as 26-52 and then 1-25. Thanks in advance! |
Pivot table sort order
You could calculate the week number to include a prefix, e.g.:
=IF(WEEKNUM(A2)=26,"A-","B-")&TEXT(WEEKNUM(A2),"00") and the weeks would sort as you want them. Vincdc wrote: Hello: I have a pivot table which is sort by week number 1-52. How can I show the order as 26-52 and then 1-25. Thanks in advance! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Pivot table sort order
Thanks for you answer! But I do not have the Analysis ToolPak add-in on my
computer; so I had to sort the order manually. "Debra Dalgleish" wrote: You could calculate the week number to include a prefix, e.g.: =IF(WEEKNUM(A2)=26,"A-","B-")&TEXT(WEEKNUM(A2),"00") and the weeks would sort as you want them. Vincdc wrote: Hello: I have a pivot table which is sort by week number 1-52. How can I show the order as 26-52 and then 1-25. Thanks in advance! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| All times are GMT +1. The time now is 05:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com