Hi ,
I am creating cube and I want to calculate the %diffence in current quarter to previous quarter for saleAmt in particular year.

I have Calender tabel on which I have created CalenderHirarachy and it's memebers are Year,QuarterName,monthName.

I have created following calculated fields.

1) Current SalesAmt :
  
  ([Measures].[SalesAmt],[Calender][CalenderHirarachy].CurrentMember)
  

2) Previous SalesAmt:

  ([Measures].[SalesAmt],[Calender][CalenderHirarachy].prevmember)

%Avg SaleAmt
  
 ((Current SalesAmt-Previous SalesAmt)/Previous SalesAmt)*100


%Avg SaleAmt should be clculated..By doing above I am not getting right result..

 Quarter SalesAmt   %Avg SaleAmt 

 Q1      4500.00
 Q2      3000.00
 Q3      2500.00
 Q4      1000.00