counting blank cell in pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi , i have a list of data where there are blank cell. i need to do a count
for the pivot table but the pivot is unable to count hw many blank data i
have. what can i do to get teh pivot to coutn my blank data. i do not want
to replace blank with any value. this is what the current pivot table is
showing.



Balance Jan Data Total
3 Count of Balance Jan 1
5 Count of Balance Jan 2
6 Count of Balance Jan 3
11 Count of Balance Jan 2
17 Count of Balance Jan 1
18 Count of Balance Jan 1
(blank) Count of Balance Jan
Total Count of Balance Jan 10
 
If you change the data field to Count Of Date rather than Count Of Balance
you will get the answer you are looking for.

Hope that helps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pivot table 1
Calculate Average in pivot item 6
Access Running Balance in Access 1
Rounding 3
Lookup functions-V lookup 1
Excel 2007 - Pivot Table and Calculated fields? 1
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Average of Subtotals in Pivot Table 0

Back
Top