K
kr
I have a pivot table in Excel based on data I have in Access. (It's easier to
see.)
The data is information that is categorized by different times of day.
In the PT,I have the times in the Row and Grouped by hour. Then a count in
values.
My issue - if I there is no data for a particular time of day, the Pivot
will not put a '0', it will just not show any information for that time. How
can I tell the Pivot if there is no info for this hour, show 0? I googled and
found info about Data Validation - if thats the answer, how do I use it?
Example
Hour
12 ---3
1 ----4
2-----5
3-----10
4-----11
*If there were no calls at 3, it would not show 3 at all. it would skip over
that row. How do I make it show '0' if when there is nothing there?
see.)
The data is information that is categorized by different times of day.
In the PT,I have the times in the Row and Grouped by hour. Then a count in
values.
My issue - if I there is no data for a particular time of day, the Pivot
will not put a '0', it will just not show any information for that time. How
can I tell the Pivot if there is no info for this hour, show 0? I googled and
found info about Data Validation - if thats the answer, how do I use it?
Example
Hour
12 ---3
1 ----4
2-----5
3-----10
4-----11
*If there were no calls at 3, it would not show 3 at all. it would skip over
that row. How do I make it show '0' if when there is nothing there?