How to display nothing instead of "(empty)" in Pivot table?

asked 2019-04-27 17:32:54 +0200

migueldealmeida gravatar image

I have a pivot table that takes a sheet with a lot of expense details, to summarise in a table "Expense Date", "value" "Description".

To do this I put the 3 columns as "row fields" in the pivot table (and Data as Column Fields).

However, expenses without description will display "(empty)" in that cell. How can I make it show nothing instead of the string "(empty)"?

edit retag flag offensive close merge delete