Pivot table sort order

G

Guest

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

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sorting dates in a pivot table 1
pivot table help 1
pivot table - sort order 2
Pivot Table Sort Order 1
Pivot Table Data Column Sort Excel 2007 1
Pivot Table - Compare Dates & calc. % 1
pivot table - show ALL detail? 3
How to sort data in excel 2000? 3

Top