LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
external usenet poster
 
Posts: 12
Default Pivot Table with Quarter Subtotals across the top

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
can i add subtotals to subtotals in a pivot table? JEM Excel Discussion (Misc queries) 1 January 23rd 09 08:15 PM
Pivot Table with Quarter Subtotals across the top [email protected] Excel Discussion (Misc queries) 1 June 20th 07 09:08 PM
Pivot Table with Quarter Subtotals across the top [email protected] Excel Worksheet Functions 1 June 20th 07 09:08 PM
Help with rolling quarter figure on a pivot table funkymonkUK[_151_] Excel Programming 4 May 4th 06 08:38 AM
Rounding to the nearest quarter (decimal) in a Pivot table Fred Excel Discussion (Misc queries) 3 April 3rd 06 03:26 PM


All times are GMT +1. The time now is 09:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"