How to calculate sales growth monthly and quarterly and added the same in drill down?
I am creating a chart to visualize the comparison between the market and products with showing sales and sales growth for monthly and quarterly. I need to add these feature in the chart as a drill-down.
My data has two tables one is a date table and another one is raw data
I have created a clustered bar graph using the country column as a market and sales. Product in the legend for the comparison. Now I need to calculate sales growth for monthly and quarterly and show it as a line in the bar graph. The idea is to show both sales vs sales growth in each market against different products. This has to be in drill-down features for both monthly and quarterly.
Could you please advise how to calculate the sales growth and also am I using the right chart?