But now, the user also wants to see Year over Year difference along with the Month over Month. When I changed Month fields used in the calculation with year-month, it did not work and shows the same values as Month over Month.
You will have to create a cumulative sum column in the back end data model or use Rangesum instead of only sum. Because the values will be aggregated based on the Month level, Even if you put Year in your set, it will only show that Month's value.
Hope this pushes you to your required output, Kindly let me know.
Not sure how that works since mine is a count and RangeSum is for Sum. And looking at the backend data model, again, there is no appropriate function to calculate Y0Y Difference. Kindly suggest a calculation that can be used on either front end or backend