Problem with Calculated Items on Calculated Fields.

G

Guest

I have sales and salespeople for three years (2004, 2005, & 2006). I have
set up a calculated field to generate average sales per sales person. Next,
I set up a calculated item to generate a % change from 2004 to 2005 (and a
second calculated item to do the same from 2005 to 2006).

In my calculated item, the results are accurate for sales and the number of
sales people.

For my calculated field, however, the percentage is way off. I can't even
figure out what, exactly, is being calculated.

Is this a pivot table limitation, or am I missing something.

Please advise. I'm using MS Excel 2003.

nick
 
D

Debra Dalgleish

It depends on how your source data is set up, but you may be able to use
custom calculations to show the difference between years, as describe here:

http://www.contextures.com/xlPivot10.html

To show the average sales, you could add the sales field to the data
area, and change its summary function to average.
 

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

Top