I have this monthly data that I need to display in a pivot table.
I am able to display Months as columns, however I need to display Total as a column for all months except last month.
Say if I have data from Jan-Jul 2019, I need a total column to average only Jan-Jun 2019, and then I need to show other columns for variance of total from July.
Please suggest how it can be achieved.
Attached is the data file.