Pivot Table - Do not sum

[KillerOfGiants]

I have a pivot table that needs to show a value (a beginning daily balance) at the most granular level of the table. However, the beginning daily balance should not be summed in any way, and only displayed when at the most granular level. Currently, I have just been masking the summed value by changing the font color to the background color, but this is cumbersome. No VBA. Is there a way?

 

[Sergius]

Hello! Show your summary (fragment) to have an idea of what's what.

 

[KillerOfGiants]

After the date, the first column (29,925,466) is the Beginning Balance. The most granular data is the date (so 146,445 for 12/28/23). The week is summed up 976,819 for that entity. All the entities for that week are summed up at 6,242,757. Etc. I only want to see the 146,445 and the column should have no values above that level.

 

[Sergius]

If I understand you correctly, then you need to go to the “Design” tab and there in “Subtotals” select the first item “Do not show subtotals”

 

[KillerOfGiants]

That works for the whole set of data. I want subtotals on the other columns.