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 ...
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.
