I created a new calculation for a measure to display Year over Year growth % using the business intelligence wizard which created new calculated members in my time dimension. How can I display the new calculation and the original value at the same time without these two options being columns or rows? For example:
2005
Sales Sales Year over Year Growth %
Product A $23 1%
Product B $45 15%
I have tried to do this using perspectives but these are not included in the 'Standard Edition' SKU. Thanks in advance.
Here is an example that should help you (from Foodmart 2000)
with
member [Measures].[Prev Sales] as '([Measures].[Unit Sales],[Time].currentmember.lag(1))'
member [Measures].[% Increase] as 'iif([Measures].[Prev Sales]<>0,100*([Measures].[Unit Sales]-[Measures].[Prev Sales]) / [Measures].[Prev Sales],0)'
select crossjoin({[Time].[1997].[Q3],[Time].[1997].[Q4]},{[Measures].[Unit Sales],[Measures].[% Increase]}) on columns,
{[Product].[Product Name].members} on rows
from sales
Hope this helps,
Santi
No comments:
Post a Comment