I am working from my bank transaction export which has separate columns for credits and debits, I have categorised each row and I want to create 2 pivot tables one for income and one for expenditure:
However each pivot table includes all categories, even though each category is only ever income OR expenditure so I get lots of gaps like:
I redo this frequently from the same formatted file from the bank and want to minimise how much work I put editing that each time - ideally I dump the new CSV in unaltered each time and regenerate the pivots. Is there any way around this?
I already checked “Ignore empty rows” but no help.
Mac, 7.1.4.2. I googled “libre office pivot skip missing rows” and a few things and couldn’t see this -apologies if I missed an obvious answer.