Hello
I created a pivot table to sort my data set for a month
I would like to have pivot table ignore blanks
Currently Pivot table is giving a 1 value for each date
maybe I filtered wrong
see attached
the column that I am analyzing has 22 cells for the month I have values in 11 of the cells
the pivot table is counting all of the cells I dont know why
In Pivot table fields I have
Filters I have nothing in there
Columns I have nothing in there
Rows I have Date month and Occurance
Values I have Occurance
Any advice would be appreciated
Bookmarks