Forum Discussion

ErikB660's avatar
ErikB660
Copper Contributor
May 29, 2024

Excel Pivot Table: Missing sum of month totals???

I am using 3 different pivot tables that link to 3 different sets of data (all configured identical format).  For two of the PT's, I am getting the monthly totals (circled in red in 2nd photo) but fo...
Excel
  • dscheikey's avatar
    dscheikey
    May 30, 2024

    ErikB660 

    You have most probably switched off the subtotals.

    In Excel for the web it looks like this:

     

     

dscheikey's avatar
dscheikey
Bronze Contributor

ErikB660 

You have most probably switched off the subtotals.

In Excel for the web it looks like this:

 

 

ErikB660's avatar
ErikB660
Copper Contributor
May 30, 2024

dscheikey You are absolutely right!!! I had the subtotal set to none instead of automatic. Thank you so much!  

 

 

Resources