View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Malinda Malinda is offline
external usenet poster
 
Posts: 7
Default OLAP Pivot Table Calculations

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