Help with Pivot Table

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)
MawallaceAsked:
Who is Participating?
 
tessupportConnect With a Mentor Commented:
SELECT CELL AQ3 AND PRESS CTRL,SHIFT AND L AND THE SAME TIME, OR UNDER THE DATA OPTION SELECT FILTER

THIS WILL ADD FILTERS TO EACH COLUMN HEADER, YOU THEN HAVE TO USE THE FILTERS TO REMOVE THE ZEROS
0
 
tessupportConnect With a Mentor Commented:
1 - on your pivot table find your row with your column titles
2 - select the empty cell at the end of the row
3 - press ctrl,shift and L

this should add an auto filter for you to allow you to filter out the zeros

hope that helps
0
 
MawallaceAuthor Commented:
Sorry - I tired that and it did not work?

Can you give me an example based on the spreadsheet uploaded!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.