Good to see this community is still alive
I am struggling with a 12 month rolling request.
We run a report with data that contains posting dates.
Now we want to make the report so it shows bij material the quantity current months and the 12 months previous.
Was thinking of making 12 previous period fields every time substracting 1-12 from the month number (but of course this gets more complicated when you get into a different year).
But surely there is a more elegant solution in these newer BO versions??
(using 4.2 SP7)
Maybe I should add that we need this rolling month in Columns!
So Curr ; M-1; M-2 etc.