Pivot Tables- Total the Subtotals?

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" <Irenerz@discussions.microsoft.com> wrote in message
news:82262CE4-31AE-4BF0-A9BF-4A8FF79D2EE5@microsoft.com...
> 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!

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" <Irenerz@discussions.microsoft.com> wrote in message
news:82262CE4-31AE-4BF0-A9BF-4A8FF79D2EE5@microsoft.com...
> 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!

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!

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" <Irenerz@discussions.microsoft.com> wrote in message
news:82262CE4-31AE-4BF0-A9BF-4A8FF79D2EE5@microsoft.com...
> 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!