Previous Year Sales !!!!

[#1]

Hi  ALl,

   Can Help e below scenario Please !!!

Year	sales
2014	2000
2013	1000
2012	1500

I want out put like this

Year	current sales	previous sales
2014	2000	1000
2013	1000	1500
2012	1500	-

And Drill down also is there if u select Quarter it should take  Previous Quarter  as well as month also is there .

my main theme is if I select any thing it should take previous sales for that particular month or Quarter or Year

please help me in this

Thanks in Advance

[chrismarlow]

Would above() function work for you, similar to attached?

[anbu1984]

Dim: Year

Exp: sales, Below(Column(1))