Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Tables- Total the Subtotals?
I've been trying to find a solution to my problem, but haven't come accross
anything realted in the posts. I have a Pivot Table with laid out like so: Data 1 Data 2 Department (12 departments)- Project Name - 2004 - 2005 I only get Totals for my department. Is it possible to get department totals for 2004 and a department total for 2005? Hopefully this all makes sense. I can only get subtotals for 2004 and 2005, for each project, I'm looking to total the subtotal for 2004 and for 2005 to get the total for the department. Would I have to use a Calculated Field? Is it even possible using excel Pivot Tables Any help would be appreciated. Thank you very much! |
#2
|
|||
|
|||
Not sure of your layout to be honest but you could always add another field
into the source data, eg assuming your date field is in Col B, then in the next blank column, title it YEAR and put in a formula such as =YEAR(B2) and copy down. That way you can easily then use that as a field to split the data on and get Totals for. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Irenerz" wrote in message ... I've been trying to find a solution to my problem, but haven't come accross anything realted in the posts. I have a Pivot Table with laid out like so: Data 1 Data 2 Department (12 departments)- Project Name - 2004 - 2005 I only get Totals for my department. Is it possible to get department totals for 2004 and a department total for 2005? Hopefully this all makes sense. I can only get subtotals for 2004 and 2005, for each project, I'm looking to total the subtotal for 2004 and for 2005 to get the total for the department. Would I have to use a Calculated Field? Is it even possible using excel Pivot Tables Any help would be appreciated. Thank you very much! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
bring back ability to format subtotals in pivot tables | Excel Discussion (Misc queries) | |||
Pivot tables - inserting columns | Excel Worksheet Functions | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions | |||
Total two pivot tables into one | Excel Worksheet Functions |