Using A Pivot Table Running Total in a Pivot Table Formula

B

bmanville

I have a pivot table with several running totals and also differenc
from pivot table fields. I would like to use these in subsequen
formulas. For example:

Booking rate in Jan is 7.50. In Feb it is 8.50. I have a field fo
booking rate with the difference in option turned on. It looks lik
1.0 in Feb. Good... Now if I have another formula to multiply thi
change by my YTD sales so that I can create an adjustment for the ne
rate, it uses the 8.50 rate not 1.0... This appears to be a
evaluation time problem... Is there a way to tell excel to evaluate th
formula after it evaluates the difference or running total? My solv
order for formulas is correct here...
 
B

BrianB

(untested)
Perhaps make a longer formula (repeating the original formula) ? ie
=YTD*(FebRate - JanRate
 

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 Sales Projections column 2
Pivot Table - copy specified Grand Totals 1
Missing Grand Total for a Calculated Field in a Pivot Table 0
How to get compound annual growth rates in pivot tables. 2
Creating a Calculated Field From a Running Total Field 1
Pivot Table Calculated Field using Grand Total 3
calculating differences in a pivot table 3
Pivot Table - Calculated Field 2

Top