Pivot totals

Bob L

New Member
Joined
May 10, 2020
Messages
21
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
So, I have the pivot table below, as you can see, I have a total for the total sales of Q4. Simple enough.

Book1
ABCDE
12020
2Q4
3OctNovDecTotal
4Cakes 20 4 87 111
5Muffins 7 15 8 30
6Chocolate 8 1 44 53
Sheet1
Cell Formulas
RangeFormula
E4:E6E4=SUM(B4:D4)


Now, I want to compare in the same pivot between the sales of Q4 of this year and last year, and have my sales forecast to compare. So now, the pivot has become like this:

Book1
ABCDEFGHIJKLMNOPQ
120202019202020192020201920202019
2Q4Q4DeltaForecastQ4Q4DeltaForecastQ4Q4DeltaForecastQ4Q4DeltaForecast
3OctNovDecTotalTotalTotalTotal
4
5Cakes 20 18 2 20 4 8 - 4 4 87 80 7 78 111 106 5 102
6Muffins 7 7 - 6 15 2 13 15 8 6 2 9 30 15 15 30
7Chocolate 8 8 - 7 1 1 - 1 44 36 8 46 53 45 8 54
Sheet1
Cell Formulas
RangeFormula
N5:Q7N5=B5+F5+J5
L5:L7,H5:H7,D5:D7D5=B5-C5


Thing is, I don't want to see the Q4 of last year and the forecast for each month, only for the total. Also, when I try to rename the totals, it says: Cannot edit subtotal, blocl total or grand total names", is there any way around it? So what I would like to see is:

Book1
ABCDEFGH
1202020202019
2Q4Q4Q4DeltaForecast
3OctNovDecTotalTotalTotalTotal
4
5Cakes 20 4 87 111 106 5 102
6Muffins 7 15 8 30 15 15 30
7Chocolate 8 1 44 53 45 8 54
Sheet1
Cell Formulas
RangeFormula
E5:E7E5=B5+C5+D5


Is it possible? Right now, I have these columns hidden and I added a row for which I have the column names I want, just want to know if's there a better way to do it.

Thanks.
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Watch MrExcel Video

Forum statistics

Threads
1,114,476
Messages
5,548,259
Members
410,825
Latest member
Dave12
Top