auto update pivot table

Riny_van_Eekelen This is really peculiar and I'm spending more time on it than on billable hours!

I copied the original data onto another WB sheet in the same wb, now labeled 2020 expenses (2), changed the data source to that sheet and refreshed the PT. Still no supplies. Went back and changed the data source to the original sheet, refreshed the PT and still no supplies row. 

Just for giggles, I used the 2020 expenses (2) sheet, created a new PT on that page and, lo and behold the supplies row showed up and in alphabetical order. So, just for the experience, I changed one of the Type Expenses to "widgets", refreshed this new PT and it showed up. 

Tried on the original sheet, changing one of the type expenses to widgets, refreshed the PT and no joy. 

The spreadsheet I sent a little bit ago was from the original sheet copied into a new wb. I didn't rebuild it. I can't understand why it works on the copy I sent you and the copied page in my original WB. That's a significant issue, at least in my mind. 

Seems that I remember that there was a way in older versions to add a subfield by checking a box, for instance, right click on Office, and pick which of the fields to display - used to be able to not show blank fields for instance. Do I remember that function correctly?