Compare % Difference 2 Columns In A Pt

Hi all

I have a pivot table with two columns; Sales 2008 & Sales 2009.

It is split by Customer.

When I generate the pivot, I can look at the 2008 Sales vs. the 2009 Sales by Customer but I cannot insert a variance column into the pivot. (i.e the percentage difference between both years).

If I insert the variance at source level then it merely adds the percentages together for my customer subtotals.

I basically want to have a variance column that calculates the variance of what ever data I have highlighted.

Can anyone help?

Da-shee

I'd like to compare Unit Sales from 2009 against Unit Sales from 2008. My source data give me Sales Date and I can grab Unit Sales count in the Value Field of the Pivot Table. I've already got other items as Column and Row Labels so I can't simply list the Sales Dates there. Additionally I need to add calculated fields based on the 2009 vs. 2008 Unit Sales. Effectively I want the end result to looks like this:

Column Label
Row Label------Model 1-----------Delta-----------% Change-------Model 2-----------Delta-------------% Change
Make 1------2009 | 2008------('09 minus '08)------('09 / '08)------2009 | 2008------('09 minus '08)------('09 / '08)
Make 2------2009 | 2008------('09 minus '08)------('09 / '08)------2009 | 2008------('09 minus '08)------('09 / '08)
Make 3------2009 | 2008------('09 minus '08)------('09 / '08)------2009 | 2008------('09 minus '08)------('09 / '08)
Make 4------2009 | 2008------('09 minus '08)------('09 / '08)------2009 | 2008------('09 minus '08)------('09 / '08)

Model 2, Model 3, etc. repeat the Delta and % Change calculated fields of Model 1.

How do I go about doing this? Do I filter the 'sub' columns somehow? How do I add the calculated fields?

Thanks!

Hi
i am looking for a macro to generate all possible combinations of N elements in C columns

for example I have 3 columns
CoL 1 Account
Col 2 Month
Col 3 Year

Independant of number of elements in each column I want to get all possible combinations of 3 elements ( not 2 or 1 element only )

example
Base is

ACCOUNT MONTH YEAR Sales jan 2007 Expenses feb 2008 Material mar 2009
apr

may

jun

jul

aug
number of combination is 3 x 8 X 3 in that case 72 lines to generate but keeping data in columns ( not concatenate field)

result is 72 lines in 3 columns

ACCOUNT MONTH YEAR Sales jan 2007 Sales feb 2007 Sales mar 2007 Sales apr 2007 Sales may 2007 Sales jun 2007 Sales jul 2007 Sales aug 2007 Expenses jan 2007 Expenses feb 2007 Expenses mar 2007 Expenses apr 2007 Expenses may 2007 Expenses jun 2007 Expenses jul 2007 Expenses aug 2007 Material jan 2007 Material feb 2007 Material mar 2007 Material apr 2007 Material may 2007 Material jun 2007 Material jul 2007 Material aug 2007 Sales jan 2008 Sales feb 2008 Sales mar 2008 Sales apr 2008 Sales may 2008 Sales jun 2008 Sales jul 2008 Sales aug 2008 Expenses jan 2008 Expenses feb 2008 Expenses mar 2008 Expenses apr 2008 Expenses may 2008 Expenses jun 2008 Expenses jul 2008 Expenses aug 2008 Material jan 2008 Material feb 2008 Material mar 2008 Material apr 2008 Material may 2008 Material jun 2008 Material jul 2008 Material aug 2008 Sales jan 2009 Sales feb 2009 Sales mar 2009 Sales apr 2009 Sales may 2009 Sales jun 2009 Sales jul 2009 Sales aug 2009 Expenses jan 2009 Expenses feb 2009 Expenses mar 2009 Expenses apr 2009 Expenses may 2009 Expenses jun 2009 Expenses jul 2009 Expenses aug 2009 Material jan 2009 Material feb 2009 Material mar 2009 Material apr 2009 Material may 2009 Material jun 2009 Material jul 2009 Material aug 2009

Thanks in Advance for helping

Can anyone help with this one?
I use Excel 2003 and have a spreadsheet that gives all sales to all customers over a period of time. Currently for 2009 it's at 46,000 rows so I have to select out the sales that are exactly the same but debit and credit as give a total between the two entries of zero. An example of this would be:

Year Month Customer Length Volume Value
2009 May A Customer & Co Ltd 3.0 (0.79) (118.50)
2009 May A Customer & Co Ltd 3.0 (1.02) (152.25)
2009 May A Customer & Co Ltd 3.0 (2.14) (321.45)
2009 May A Customer & Co Ltd 3.0 (1.33) (198.75)
2009 May A Customer & Co Ltd 3.0 1.02 152.25
2009 May A Customer & Co Ltd 3.0 2.14 321.45
2009 May A Customer & Co Ltd 3.0 0.66 99.45
2009 May A Customer & Co Ltd 3.0 1.03 154.35
2009 May A Customer & Co Ltd 3.0 0.79 118.50
2009 May A Customer & Co Ltd 3.0 (0.66) (99.45)
2009 May A Customer & Co Ltd 3.0 1.03 154.35
2009 May A Customer & Co Ltd 3.0 1.33 198.75

Does anyone have an "easy" method of doing this rather than manually?

Thanks again.

Cheers

Aargh!!

I have a pivot table which shows sales by customer by year. I created a field to show the difference in sales year over year. Is there a way to only show the comparison field once? It currently shows up in both 2009 and 2010. Also, I want to then sort the table by the difference in sales. This all seems basic to me but I can't get it to work. Thanks.