Hi,
I want to see all the measures on Yearly basis. So I have created a table where I have put all the measures and Year in the filter.
In the last row we have Profit there for 2009. The twist is I have to see Profit for previous year. I mean to say once I select 2010 then I
should see profit of 2009, when I select 2011 then I should see profit of 2010 and so on.
Is it possible to achieve the above in the same table or do I need to create a different sheet for this?
Ajit
3 answers
