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!

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

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