I am looking for a report showing various figures for a selected month and at the same time
1. sums of the selected month and the two month before (add the figures of three months) ("3 month rolling") and
2. sums of the selected month and the eleven month before (add the figures of 12 months) ("12 month rolling").
My idea is to set variables depending on the selected month or use the selected month in formulas to get to the 3-month figures and 12-month figures, but I did not find a way to do this. Is this possible ?