Pivot Table Report- Calculated: Field From Next Column

  • Thread starter Matt Pierringer
  • Start date
M

Matt Pierringer

Here is my problem, I have a Pivot Table setup to display Catalog
Numbers and it is showing the price changes throughout the months and
years. Would it be possible to calculate the same field in the next
column, i.e:
Price this month ||Price next month
004622SP $39.00 $43.00
10P $12.25 $13.50

Calculated field would be as follows(taking percentage):


(($39 / $43.00) - 1)(-1))*100 = 9.30
(($12.25 / $13.50) - 1)(-1))*100 = 9.26

My query that I am grabbing that info from is setup like this:
Catalog Date Price
004622SP 6/1/2005 $39
004622SP 9/8/2005 $43
10P 6/1/2005 $12.25
10P 9/8/2005 $13.50


Is there any possible way of doing this, or are there too many
complications?
Thanks,
Matt Pierringer
 

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

Pivot Table Calculated Field 0
Calculated Field in Pivot Table 1
Insert Calculated Field (wrong Qty*Price = wrong Amount) 8
Creating a Calculated Field in a Pivot Table for same field 3
Pivot Table Subtotal of Calculated Field Problem 3
pivot table calculated item creates unneeded rows 0
Calculated field problem in a Pivot table 0
Total Not Summing Correctly on Calculated Fields in Pivot Table 0

Top