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.