Forum Discussion
Pivot table is counting empty cell
To all the Excel gurus, I have a spreadsheet which has data after a date 10/3/18. However, when I created a pivot table, it created a new group for the dates before 10/3/18 and even generated th...
Right-click the date field and select "Group...". Make sure the two check-boxes at the top are checked.
Thank you so much! The solution is so simple! How come I didn't know?!
Thanks again!
