Hi everibody, I need your help on design MDX query.
I want to compute the difference in payments respect to a given date: sum(payment of two last years) - sum(payment on next year) and shows it by quarter.
Maybe I'll have to calculate two different MEMBER, "PREV TWO YEARS" and "NEXT YEAR" respect to the given date and then make a difference between them....
PREV TWO YEARS <-- SELECTED DATE --> NEXT YEAR
Which is the best way to do this?