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!!!!!!!!!
May be you can create one more transaction table by residenting the table where you have your 'Data' field and just replace the date fields with adding one quarter and renaming field 'data' to 'Data2' and use this field for your second expression.
I hope I was able to explain what I mean to say.