Year over Year / Month over Month comparison in a chart
Hi,
I have a need to do a year over year, month over month comparison in a bar/line combo chart. The bar measure would display the difference in 'sales' numerically, and the line would show the percent change.
Example data for Year over Year:
Mar-2022 10000
Apr-2022 10000
Mar-2023 11000
Apr-2023 15000
In the bar/line combo chart, I would show the months across the bottom as the dimension. For March, the bar would show 1000 and April would show 5000 (the difference in march 2022 vs march 2023 and april 2022 vs april 2023). The percent line would be the percent change (March would be 10% and april would be 50%).
Example Data for Month over Month:
Mar-2023 11000
Apr-2023 15000
The bar for April would show 4000, the difference in growth between the two months, the percent would be 36%.
A lot of searching the forums shows me how to calculate one individual month comparison but it doesnt work in a chart with all 12 months.
