Pivot Table with Quarter Subtotals across the top


D

dvpetta

Hello,

I'm constantly creating pivot tables that show sales information by
date across the top from left to right. I would love to insert a
subtotal at the end of each calender quarter to subtotal the last
three months. As it stands right now I just drop in the "Month" field
from the data into the pivot table and the months flow through the
pivot table.

Is it possible to insert a quarter subtotal, say "1Q07" that will sum
Jan-07, Feb-07 & Mar-07?

Thanks in advance,

Dza
 
Ad

Advertisements

B

Bob

In 2007-

Select any date heading, on the options ribbon click Group Field in the
Group group, the grouping dialogue box should appear, you can select group
by quarter
 

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

Top