Pivot table group by

[Ofina]

I have a pivot showing customer orders. I would like to see the totals by year, but with 2010 being split into quarters.

Can I do this?

 

[SkipVought]

Hi,

YES, is you are using REAL DATES.

Right click the date field in the PT and select GROUP and then the YEARS and QUARTERS.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Ofina]

But, that displays years and quarters for all the years. I only want 2010 broken down and the rest 2009, 2008, etc grouped by year only.

 

[SkipVought]

What version of Excel?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Ofina]

I currently have 2003, but I can have access to 2007, if need be.

 

[SkipVought]

in 2003 yer stuck.

In 2007, you can expand/collapse the quarters you do/don't want to view.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[fishymetrics]

in 2003 you can hide the qtrs that you don't want.
Highlight them, right click, Group and Show Detail, -Hide