Don't count empty cells in pivot table

[Anwesh Gangula]

I have a data exported into an XML file which I map into excel. Then I convert this data into a pivot table to get the total count necessary columns. 

In the attached excel file, I'd like to get a count of "Trades" column only if the corresponding cell in the column "Clashes" is filled/not empty. But using the pivot table it counts the value even if the cell is empty. How do I achieve this? 

For example, in the file, "07.NetOps" is completely empty but the pivot table gives a count "1" for it. Is there any way to ignore the cell for counting if the "Clash" & "Active Clash" columns are empty?

[#2 · Accepted solution]

Anwesh,

add a column "Empty?" to your table with this formula:

=COUNTA(C2.E2)=0

Drag the fileld into the report filter and filter for FALSE.