Calculate % based on previous cell values -
05-11-2006
, 10:35 AM
I am trying to calculate a % by dividing current cell by the value in
the previous cell.
I have months and delinquency buckets...
So, Dec 2005, Jan 2006, Feb 2006 has buckets of current, 0-30, 31-60
etc.
Now, to calculate 31-60 days % for Jan 2006, I want to divide that cell
value by the value in Dec 2005 under 0-30. Is this possible to do
through MDX on Analysis Manager? Can anyone shed some light on this?
Thanks! |