Pivot Table Formulas

A

AJ

I need to create a variance formula for the data selected in a pivot table.
My problem is that the data is coming in from one column and I don't know how
to distinquish the data by year in the formula. I have put a small selection
of my data below. I would like to show the variance between 2009 and 2010
for all months selected in the pivot table.

WDS# EA UOM PRICE EXTENDED Month Year
0623864 6 EA 9.73 58.38 Jan 2010
4286879 2 EA 2.784 5.568 Jan 2010
0623864 9 EA 9.73 87.57 Feb 2010
4286879 1 EA 2.784 2.784 Feb 2010
3514738 1 EA 13.72 13.72 Feb 2010
0623864 5 EA 7.85 39.25 Jan 2009
4286879 6 EA 2.784 16.704 Jan 2009
4286879 4 EA 2.784 11.136 Jan 2009
3514738 3 EA 8.29 24.87 Feb 2009
0624594 3 EA 4.23 12.69 Feb 2009
927-194 59 EA 0.79 46.61 Feb 2009

There are several hundred rows of data each month.

Any help would be greatly apprciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Information for Pivot Table 3
How do I set a pivot table to group quarterly reports by F/Y? 2
Pivot Table and Grouping Problem 3
Pivot Table field selection order 7
Subtract colums in pivot table 0
Pivot table field. 2
#DIV/0! in a Pivot Table 1
Pivot Table Set Up 2

Top