Hi,
I want to do some calcualtions in the Pivot after the data is fetched from SSAS 2005. Can anyone suggest how this is possible
e.g. I have two measures: 'Total Revenue' and 'Total Sales volume' and I want the new member on the pivot to be 'Revenue Per Product (i.e. division of the first two measures)'
Any anone help
regards
Josh