Please find the dummy data as an attachment.
I have one dimension YearQuarter and two expression A1 and B1.
I want to calculate B1 expression in such a way that whatever data i have in A1 for YearQuarter=2016Q1 that should come in B1 for YearQuarter=2016Q2 and whatever data i have in A1 for YearQuarter=2016Q2 that should come in B1 for YearQuarter=2016Q3 and so on.
Can anybody give me the solution?
Thanks for your help!!!!!!!!!