Can't add a column to pivot tables!

Question

Can't add a column to pivot tables!

Hi.

I have a spreadsheet that lists (rows) various investment accounts (a dozen +/-) and monthly balances (columns).

I created a few pivot tables to analyze the data based on some characteristic or other.

In my main chart, I have now added a column in preparation for the April monthend.

However, I can not add that column in my pivot tables!!! When I go to "Pivot Options", that column is not listed in the "Fields". 2023-12-31, 2024-01-31, 2024-02-29 and 2024-03-31 are there, but not 2024-04-30!!!

What am I doing wrong?

Thanks!

Mac mini (M1, 2020)

Posted on Apr 27, 2024 11:54 AM

Reply

Answer 1

Apr 27, 2024 7:36 PM in response to skdjfhskfjshf

Please select your pivot table first, and then click on the refresh button in the sidebar.

Alternatively, you can click the area below the Source Data to reset the source data area for the PivotTable.

Reply

Answer 2

Apr 28, 2024 7:37 AM in response to OliviaMarsh

Olivia! Thanks for the response!

Your suggestion was exactly what I was doing (except that in the "Source Data" field, it showed the table name, not the coordinates as in your example). Nevertheless, that's what I had been trying all afternoon yesterday, and that did NOT work.

But I did find the solution to my problem this morning: keep in mind that I had created the "2024-04-30" in preparation for the coming month-end. Of course, there was NO DATA yet in any of the cells of that column. Well...(drumroll here...) I put 0 (yes, zero) in one of the cells, and, BINGO, now the column is visible in the Fields box of the Pivot Options!!!

What a way to live!

Well, thanks for responding and sort of forcing me to take another look at my problem!

Have a nice day.

Reply