You can actually see this without creating a calculated field! The workbook attached shows this on the 'MoM - Table Calculation'. You can use a Quick Table Calculation to show the percent difference:
If you'd like to use a calculated field with these 2 months as a base, look at the 'MoM - Calculated Field' sheet in the workbook attached. I've used a few fields to split the problem into pieces:
1. Monthly Amount: Returns the SUM of Amount for each month. This uses and LOD expression.
2. August Value & September Value: These use the calculated field above (1) to return a value for each month.
3. Calculated Field - MoM: Shows the ratio between the monthly fields above (2).
Hope this helps!
MoM.twbx 7.4 KB
Thank you very much for your reply and help! I can't manage to open the workbook you attached because it gives me an loading error... can you try attaching it again?
In the calculated field, can I put in some sort of variable so that it gives me a month on month calculation for any two months I choose? Something like a runtime prompt?