Mawallace
asked on
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)
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)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Can you give me an example based on the spreadsheet uploaded!