Could you specify the delta you are seeing with some example with your sample data?
Which year's which scenario's which month?
What is wrong and what is expected?
My table calc is matching up with another calculation I have earlier on.
Ideally, the two line graphs should match up. I think it is because of the "THIS" calc. is a table calculation. It is based off an aggregation so I resorted to WINDOW_SUM.
I attached the workbook too.
I want the values from the "THIS" table calculation to recreate the same line graph produced by Ranged1_AGG_SumStat.
Nevermind! I have everything I need. After doing a duplicate of the crosstab, I realized that I filtered my months to only October-January when my base graph is from October-September. Everything is working as intended.