Dear All ,
I am writing one query on an infocube in which i have to do year to date(YTD) comparision of a key figure and then subsequently calculate its growth % also.
eg. Category YTD (Current year) Volume YTD (Previous Year) Volume Growth%
ABC 50 30 (50-30)/30*100
I am able to display till YTD(Prev Year) , but unable to calculate the growth%.
In my infocube i have category & its volume according to year , therefore i am able to display till YTD.
My volume is coming in a single key figure only.
But how to calcualte Growth% in query itself.
How to apply formula on keyfigures in a row??
Kindly help.
Regards,
Sonali