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 :
2) Previous SalesAmt:
((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
Vijay is here to learn something from you guys.