Forum Discussion
Solved
Don't count empty cells in pivot table
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?
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.
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.
