T
TomS
I am trying to make a pivot table to show the monthly
average over a 12 month period. However some months have
null data (i.e. they are zero). When it calculates the
average it does not factor in the months with null
values. How do I get it to count the months with null
values?
average over a 12 month period. However some months have
null data (i.e. they are zero). When it calculates the
average it does not factor in the months with null
values. How do I get it to count the months with null
values?