Hi all,
I notice in a pivot table, it doesn't show null/zero value when you have an aggregated function in the data area.
For example.
if you have "week" in row ranging from week 1-20
and you have "avg. # of accidents" in the column
if week 5 did not have any accidents, the row week 5 is not shown.
I want to get the pivot table to show week 5, and 0 as the avg. # of accidents...
Can someone help me please?
Thanks.
Bookmarks