YoY comparison

Question

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.

mceleavey · Answer

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.

YoY_Mceleavey.yxmd

cjaneczko · Answer

There are better ways to do this if you have the actual quarters or dates brought into the workflow. But if the data is how you have it presented above, this workflow should work.

YoY Comparison.yxmd