Pivot tables - calculated fields and items

Giganews Newsgroups
Subject: Pivot tables - calculated fields and items
Posted by:  Tim Wheeler
Date: Thu, 18 May 2006

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?

Replies