HOw do i exclude 0 in Pivot table Count

Attached is a sample of my company aging when pull from system. It put a 0 in all the blank. Hence my pivot table will include it when counting. Hw do i solve it?

Assuming you cannot modify your source perhaps you could you add a Calculated Field, and replace your existing data field (Count) with this Calculated Value (Sum)

Formula:

Please Login or Register  to view this content.

repeated for each of your source fields (30, 60, 90 & 120)

Hi, the formula onli return the Max, hence it only reflect one invoice. I tried to change some of ABC invoices to 30 Days, however, Field1 still only show 1.