Hey everyone, Im trying to make a pivot table out of my sales data, when I enter the date in the rows field while making the table it says they cannot be grouped. I'm using a random date generator which is =RANDBETWEEN(DATE(2020,1,1),DATE(2023,12,31)), as I've got 26000 rows. Ive also tried to just enter the date itself in the format 01/02/2023 but its still not working.
I've looked up online as well but as I'm using a random date generator there can't be any alphabets or anything in the rows which usually causes the problem.


My end task is to build a dashboard but I cant get through the date problem.