Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table
I have a Pivot table summurizing data where years and quarter are in the row
label and average af amount in Values: Values Years Date Average of Amount $2 % diff previous Q 2005 Qtr3 $283.96 Qtr4 $344.83 21.43% 2006 Qtr1 $462.70 Qtr2 $603.55 30.44% Qtr3 $665.53 10.27% Qtr4 $674.41 1.33% 2007 Qtr1 $665.95 I run % difference from (previous), but i can't get say Q1 2006 % Difference from the previus Q (Q4 2005) and the same for every Q1 with respect of the Q4 of previous year, all the rest of course works fine. Any hints? thanks Andrea |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Pivot Table Question : If statment in Pivot Table?? | Excel Discussion (Misc queries) | |||
Pivot table keeps dupping to another linked pivot table | Excel Discussion (Misc queries) | |||
pivot table: create worksheetsheet using pivot table | Excel Discussion (Misc queries) | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel |