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...
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...