Pivot tables

Hello Lesley,

Thank you for your question. Here are two possible ways to remove rows with zero amounts in a Pivot Table:

Method 1: Use a Helper Column in Source Data
Add a helper column to your source data:
Example formula (assuming Amount 1 in column B and Amount 2 in column C)
=IF(AND(B2=0, C2=0), "Remove", "Keep")
Refresh your Pivot Table and add the helper column as a filter.
Filter to show only "Keep" values.

Method 2: Use Pivot Table Value Filters
If you're working directly in the Pivot Table (and not using a helper column):
Click on the row label dropdown in the Pivot Table.
Choose Value Filters > Greater Than.
You’ll only be able to filter on one column this way, so:
First, filter on one value field to remove zeros.
Then manually hide rows where another value field is also zero (or use conditional formatting to highlight them).

I hope this helps. Please post again if not.

Kind regards
Marius Barnard
STL