Pivot Table Issue

[dixiebritt]

I have a pivot table to count the number of clients billed per quarter. The quarters only have a number in the total if they had Billings ; otherwise it is blank. I have one branch who had billing in q1 , but none in the remaining. However my pivot shows the same number billed in q1 in the remaining. Why would this count “blank” cells? Hope I am explain this correctly

For example:
Column A (has company names) Columnns Q-AC, have their billings and AD - is the formula to add the billings for each client. If they didn't have billing for quarter, AD is empty. I want the pivot table to only count the number of clients who had billings for the quarter.

 

[pbornemeier]

What is the formula in column AD?
Is Q-AC weeks in the quarter?
I believe the example describes the raw data. What data elements are in the row, column, values, filter portions of the pivot table?
What summary setting is used for the data (sum, count, average, etc.)

 

[dixiebritt]

the formula is: =IF(SUM(Q14:AC14)=0,"",SUM(Q14:AC14))