Pivot table sort order

V

Vincdc

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!
 
D

Debra Dalgleish

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.
 
V

Vincdc

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.
 
Top