I need help to retrieve the last 8 closed quarters, in order to compare them with each other. And this needs to be done using set analysis.
My data format in the [Quarter] field is for example: 2018Q02
I should have the 2 last closed quarters as variables in order to perform sum and calculations between them, for example:
Quarter for today() = 2018Q04. So, as long as we need the closed quarters:
$LastQuarter = [Quarter]-1 = 2018Q02
$2LastQuarter = [Quarter]-2 = 2018Q01
Once i understand the mechanic behind it, i can try and solve the other closed quarters that i want.
I've been trying to do this, but nothing is working at this moment.
Thanks for the help!