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

[ErikB660]

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 for the middle (2023) it does not bring back an value.  When I hover over the cell, it shows value: 0.  Please help.  What am I doing wrong?

[#2 · Accepted solution]

@ErikB660 

You have most probably switched off the subtotals.

In Excel for the web it looks like this:

[#3]

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