K
ker_01
I have some data in the format:
Name Year Sale$
Jill 2008 15
Jill 2008 29
Mike 2008 12
Mike 2008 53
Jill 2009 24
Jill 2009 43
Mike 2009 17
Mike 2009 26
Pivot table is set up as:
2008 2009
Sum of Sales$ Sum of Sales$
Jill 44 67
Mike 65 43
(in reality, there are several columns under 2008 and 2009, showing other
performance data as well)
Now I want to show a year-to-year comparison; a calculated column that would
show:
2008 2009 Annual
Sales$ Sales$ Change
Jill 44 67 23
Mike 65 43 (22)
I can do this with calculated columns when the source data is all from
different columns, but I haven't figured out how to do it across multiple
pivot table columns that pull from the same source data column and are just
differentiated by a higher-order split, in this case, year.
Is this possible in Excel2007, and if so, can someone provide some direction?
Many thanks,
Keith
Name Year Sale$
Jill 2008 15
Jill 2008 29
Mike 2008 12
Mike 2008 53
Jill 2009 24
Jill 2009 43
Mike 2009 17
Mike 2009 26
Pivot table is set up as:
2008 2009
Sum of Sales$ Sum of Sales$
Jill 44 67
Mike 65 43
(in reality, there are several columns under 2008 and 2009, showing other
performance data as well)
Now I want to show a year-to-year comparison; a calculated column that would
show:
2008 2009 Annual
Sales$ Sales$ Change
Jill 44 67 23
Mike 65 43 (22)
I can do this with calculated columns when the source data is all from
different columns, but I haven't figured out how to do it across multiple
pivot table columns that pull from the same source data column and are just
differentiated by a higher-order split, in this case, year.
Is this possible in Excel2007, and if so, can someone provide some direction?
Many thanks,
Keith