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)