I want to only figure out the count of HM that equals 1, however, whenever I drag it to pivot table, TP Code count is always equal to HM(see below screenshot), I indicate the supposed result. HM Column consists of blank or 1 number if the condition meets on another column. How can I only count the supposed result?. I already used the calculated field but any count formula is not acceptable. Appreciate your help.
Screenshot_7.jpg
Bookmarks