Hi Tim

From the PT toolbar, use the Pivot Table dropdownFormulasSolve order

--
Regards

Roger Govier


"Tim Wheeler" <Tim wrote in message
...
have a time series of volumes and revenues for a number of landfill
sites.
Within a pivot table I have a calculated field working out average
price. I
also have in the time dimension calculated items providing an
indexation over
time of each field (volume, revenue and price against time zero).
Unfortunately the order of calculation seems predefined so that the
indexation is calculated first and the average price second which
invalidates
my indexed average price. Has anyone come across this problem and is
there
anything I can do to change this order or workaround this problem?