[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
Solved

# Pivot table problem with summary

Posted on 2011-10-17
Medium Priority
210 Views
Hello Experts,

I am having a strange issue with a pivot table our finance people are trying to use.  I have attached an example file which shows the problem.

Basically we are using a data sheet to populate a pivot table and show us change of sales information.

Sheet one holds the data for the pivot on sheet4.  I have removed the 40,000 other rows which hold the rest of the data.
As you can see all the calculations in the pivot are working except for the last column, Q (2011 summary of change in units).  This column is supposed to give us the difference between the unit sales in 2010 and 2011.

Instead of that result we seem to be getting the difference between 2010 \$ sales and 2011 unit sales.  We need the difference between 2010 unit sales and 2011 unit sales.

Can anyone see what the problem here is?

Nemanya
Example.xlsx
0
Question by:ApogeeIT

LVL 11

Expert Comment

ID: 36982451
Try looking at it this way
Example.xlsx
0

LVL 85

Accepted Solution

Rory Archibald earned 2000 total points
ID: 36984577
You could use a calculated item in the Year field (defined as just 2011-2010), as in the attached. It may be slower with a lot of data though.
Example--1-.xlsx
0

Author Closing Comment

ID: 37077333
Thanks Rory this is what we needed to do.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a serious pitfall that can happen when deleting shapes using VBA.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
###### Suggested Courses
Course of the Month17 days, 15 hours left to enroll