“Analyzing Payment Data: Comparing Monthly Totals and Company Payments”

TAB A
1. Create a Pivot Table to show how much was paid total per month (column C) for each month (column H)
2. Create a Pivot Table to show how much was each Company (column B) paid in total (column C)

TAB B
1. Create formulas to show the variance between 2019 & 2020 payments per month as a dollar value difference and another column to show this difference in % for both tables
2. (Optional) Create a small graph to show the totals paid in 2020 vs 2019 per month.