While submitting the report of the sales we canâ€™t able to avoid the information of variance between previous periods and for this purpose we need to go for the formula and which will take much time for making interactive report, But in Excel pivot table make this task very easy by just click.
Create a Pivot Table from the Data,arrange the headings by category to row labels and date to columns labels and group the the dates to month, after the drag the Total heading to the value fields
Drag again the total heading to the value field and click on the right arrow and click on the value field settings and click on show value as from this select % difference of option.
And select the previous option and click OK and now we can able to compare the report month to month by selecting the months from the filter option.
Video Link: Watch Video