Calculated field on Pivot

[bavarunbansal]

Hi People,

Hope you are doing well. I've a query regarding pivot table.
I am trying to filter rows from the pivot table which have all the values populated. Attaching screenshot for reference.


Capture.PNG

In the attached image, from the pivot table, I want to filter out rows which have certain blank columns (highlighted in yellow). There are thousands of rows in the original data set.
I tried applying coutifs in calculated field, but couldn;t succeed. Could you suggest something to solve this?

Thank you
VB

[oeldere]

HOW TO ATTACH YOUR SAMPLE WORKBOOK:

Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.