Hi , I am facing an issue in calculating the growth of a company between years. Following is my dataset :- I need to calculate growth for every year i.e Growth = Amount in 2011 - Amount in 2010 and so on. in above table growth for 2011 will 0.28, , 0.09,0.00 and for 2010 it will be 0.28-0.33, 0.00-0.08, 0.09-0.05, 0.00-0.00 Please help!Thanks & Regards, Chaitali Thaker

Hi Chaitali, is this a Matrix or a Table ? I Presume you have to do it at the Query Level. If possible let us know the Query . Rakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://myspeakonbi.blogspot.com/

Hi Rakesh, It is a Matrix. The table consists of dim_Branch name, dim_Calendar_Year, Amount(measure). I need to get the above output in a report. how can i do it at a query level. do i have to create a calculated member in a cube? Please suggest.Thanks & Regards, Chaitali Thaker

MSDN_new, If you want to do this in report itself, then you can make it possible but it will not be an ideal solution though. Nevermind, here is a way: Create different datasets for every year. eg. Dataset 2010 Branch Name Amount Dataset 2011 Branch Name Amount etc.... Then, in your matrix you can use the Lookup() - works in BIDS 2008 R2 Lookup(Branch Name, Branch Name, Amount, "Dataset_2011") will give you amount in 2011 for particular branch. If the number of years for which you want to show the growth in your report are less, then go ahead with this strategy! Regards Manoj

Hi Manoj, Thanks for your solution. But,since the no. of years in my dataset is large i cannot go with the suggestion. Insstead i created a calculated member in my cube using PREVMEMBER and got the solution. Thanks All. Thanks & Regards, Chaitali Thaker