Hi! badly need your help or any idea on this.

I need to create a calculated member wherein I'm going to display the %
Increase/Decrease between two different years. For instance, given
measure is Sales. I need to get the % increase/decrease on sales for
year 2006 and 2005.

I'm new in using Analysis Manager, please help me. Thanks is advance!

Here's a sample Adventure Works query, showing sales growth:

iif(IsEmpty([Measures].[Sales Amount]) or
IsEmpty(([Measures].[Sales Amount], [Date].[Calendar].PrevMember)),
NULL, ([Measures].[Sales Amount] -
([Measures].[Sales Amount], [Date].[Calendar].PrevMember))
/([Measures].[Sales Amount], [Date].[Calendar].PrevMember)),
FORMAT_STRING = 'Percent'

select {[Measures].[Sales Amount],
[Measures].[SalesGrowth]} on 0,
Non Empty [Date].[Calendar].[Calendar Year].Members on 1
from [Adventure Works]
------------------------------------------------------------
Sales Amount SalesGrowth
CY 2001 $11,331,808.96 (null)
CY 2002 $30,674,773.18 170.70%
CY 2003 $41,993,729.72 36.90%
CY 2004 $25,808,962.34 -38.54%

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Hi Deepak,

Thanks for the info. I'll try this one.