Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Pivot Table with Quarter Subtotals across the top
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 wrote in message oups.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Subtotals | Excel Discussion (Misc queries) | |||
Rounding to the nearest quarter (decimal) in a Pivot table | Excel Discussion (Misc queries) | |||
Subtotals in a Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table Subtotals | Excel Discussion (Misc queries) | |||
Pivot table subtotals 100% | Excel Discussion (Misc queries) |