How to make pivot table and pivot chart show 0 for "Poor"?
Thanks.
How to make pivot table and pivot chart show 0 for "Poor"?
Thanks.
You would, I think, need to add a "Poor" record to your table but, importantly, leave Name blank; then:
C2: =(A2<>"")+0
which should cascade your table
refresh your Pivot, replace Count of Grade with SUM of new field (C)
(obviously, you could replicate the above for the other 4 fields - to future proof - and perhaps put these 5 records as the first 5 in your table - )
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks