Hi,

The OLAP fact has no impact on this.

Suppose you have pivot table with a column field called year with two years,
and a row field called department and a data field called Amount.
Double-click the Sum of Amount field button, and in the Pivot Table Field box
click Options. Open the Show Data as drop down and choose Difference from.
Then pick Year field under Base field and pick either year in the Base item
area.

Remember to click Yes if this information helps.
--
Thanks,
Shane Devenshire


"Malinda" wrote:

How can you add a column to an OLAP pivot table to show the difference
between values in two columns. We need to show data for two different dates
and then show the change (financial reporting). Unfortunately, it's not a
year over year or quarter over quarter, or any other standard timeframe,
otherwise we could calculate it in the SSAS cube.

Thanks in advance for any insight.

Malinda