Question: how to calculate year over year percentage in excel?
Answer: From the current month, sales subtract the number of sales of the same month from the previous year. If the number is positive that the sales grew.
Divide the difference by the previous year's total sales.
Convert the value to percentages.