Hello,
I saw that this problem is known but could not find a workaround or a solution.
I wanted to make a simple pivot table to track incomes/expense etc.
I made a sheet where I add my transactions divided by categories (for example salary) day by day.
Creating pivot table I used date as columns and categories as rows.
Automatically it groups date by month and years.
To add the calculated item (example net = income-expenses) I had to ungroup the dates.
After that I would like to group again by month and years but it's not possible anymore after having added the net item.
Is there a way to obtain this result?
Bookmarks