I have created a pivot table.
I want, where the results are zero for a row , for the pivot table to remove the results from the table.
See the spreadsheet below.
Where the results for "biffa" row 2 - each line in the columnstacey2013accountsamended.xlsx
is zero or had no value. - I would want that row omitted from the pivot table (as it clutters up the table)