Mar 12 2019 02:26 AM
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 the total for the sales before that date, which don't exist at all!
Anyone has an idea where and why there is data before that date? Is there any way I can get rid of it?
Mar 12 2019 03:15 AM
Right-click the date field and select "Group...". Make sure the two check-boxes at the top are checked.
Mar 12 2019 12:53 PM
Thank you so much! The solution is so simple! How come I didn't know?!
Thanks again!