I would need to do YoY comparison with period B (5+6+7+8) being compared to period A (1+2+3+4). This logic will be repeated for subsequent periods when period C (9+10+11+12) gets compared to period B (5+6+7+8).
This is taking a sum of all quarters of current year to compare with sum of all quarters of previous year.
Hi @satya04 ,
for this, I would use the CEIL([Qtr]/4) function to group the record ID field (Qtr) into groups of 4.
From there, simply sum and crosstab.
This gives the following results:
I hope this helps,
M.