I want to be able to choose not to display nil balances in the total collumn
on pivot report.
One way of doing this is to amend the database itself and delete all items
which adds up to zero but this is a very long process.

Is there a way without having to change the source data to generate a
create a pivot table which dose not show the zero balances.