asked on

Filter pivot table results / calculated field

Hello!

My pivot table has a simple calculated field: Charges - Payment. I need the pivot table to show me only "0". How do I filter on it?

thanks

Subodh Tiwari (Neeraj)

You can experiment it by creating a calculated field in the data table and create a helper column to check if the calculated field contains 0 and then return a True else a False in it. Now you may add that helper column in the Report field of pivot table and apply filter to show True only.
The formula for the helper column would be something like this....

=IF(D2=0,TRUE,FALSE)

Open in new window

Where D2 is the cell in the Calculated Field Column and this formula can be placed in col. E to return True or False based on the values returned by the Calculated Field.

If this doesn't help, you may consider uploading a sample workbook.

Tom Farrar

Try this....
Filter-Zero.xlsx

Subodh Tiwari (Neeraj)

+1 Tom. :)

Ladkisson

ASKER

Tom,

I see that you managed to insert a filter on the calculated field, but I don't know how you did it....

ASKER CERTIFIED SOLUTION

Subodh Tiwari (Neeraj)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Ladkisson

ASKER

Yea, I figured that out already:) Thanks!

Subodh Tiwari (Neeraj)

You're welcome. Glad I could offer some help.

Also you accepted my reply as an accepted solution, instead you should have accepted Tom's solution as an accepted solution or you could split the points.
If you have done this unknowingly, you can use Request Attention feature to reopen the question and reassign the points.

Tom Farrar

Thanks, sktneer, it was a joint effort. - Tom