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)”?