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?