Hi
I created a pivot table but when I tried to filter by Year, the filter is showing me 2 dates beside Year 2021 and 2021 and beside each date is symbol >
<07/01/21 and >18/12/22 Why is that? When I filter the date column in the original data set, I see everything is ok , the 2 years, 2021 and 2022. Please see screen shots. I checked
the original table, and used IsNumber function to see if all dates are formatted as a number and the answer was TRUE to all.
Thank you very much.
I created a pivot table but when I tried to filter by Year, the filter is showing me 2 dates beside Year 2021 and 2021 and beside each date is symbol >
<07/01/21 and >18/12/22 Why is that? When I filter the date column in the original data set, I see everything is ok , the 2 years, 2021 and 2022. Please see screen shots. I checked
the original table, and used IsNumber function to see if all dates are formatted as a number and the answer was TRUE to all.
Thank you very much.
SalesPerson | Date | Amount | Region | |||||
Helen | 23/04/21 | 295 | East | |||||
Helen | 26/06/21 | 776 | East | |||||
Helen | 10/02/22 | 511 | East | |||||
Helen | 25/04/22 | 225 | East | |||||
Helen | 25/06/22 | 168 | East | |||||
Helen | 10/02/22 | 990 | East | |||||
Helen | 21/01/22 | 624 | East | |||||
Helen | 16/07/22 | 157 | East | |||||
Helen | 22/03/21 | 245 | East | |||||
Helen | 01/02/22 | 709 | East | |||||
Helen | 25/10/22 | 242 | East | |||||
Helen | 19/05/21 | 135 | East | Years | (All) | |||
Mona | 27/09/21 | 223 | south | |||||
Mona | 23/03/21 | 972 | south | Sum of Amount | ||||
Mona | 11/04/22 | 278 | south | Ajit | 6225 | |||
Mona | 20/06/21 | 647 | south | Alexander | 5643 | |||
Mona | 12/09/22 | 996 | south | Ali | 4447 | |||
Mona | 31/05/21 | 355 | south | Helen | 5077 | |||
Mona | 17/12/22 | 296 | south | Jack | 3237 | |||
Ajit | 22/02/22 | 701 | West | Linda | 8342 | |||
Ajit | 09/09/22 | 352 | West | Mike | 6933 | |||
Ajit | 15/01/21 | 379 | West | Mona | 3767 | |||
Ajit | 17/03/22 | 736 | West | Sam | 5553 | |||
Ajit | 20/04/22 | 601 | West | Grand Total | 49224 | |||
Ajit | 04/05/21 | 501 | West | |||||
Ajit | 19/10/21 | 260 | West | |||||
Ajit | 06/07/22 | 395 | West | |||||
Ajit | 13/07/21 | 308 | West | |||||
Ajit | 22/08/22 | 973 | West | |||||
Ajit | 19/02/21 | 567 | West | |||||
Ajit | 07/03/22 | 452 | West | |||||
Jack | 15/10/21 | 256 | East | |||||
Jack | 09/07/22 | 238 | East | |||||
Jack | 21/09/21 | 256 | East | |||||
Jack | 09/04/22 | 306 | East | |||||
Jack | 17/08/21 | 194 | East | |||||
Jack | 04/04/22 | 179 | East | |||||
Jack | 11/11/21 | 934 | East | |||||
Jack | 29/11/22 | 874 | East | |||||
Ali | 25/07/22 | 868 | North | |||||
Ali | 15/07/21 | 150 | North | |||||
Ali | 17/05/21 | 781 | North | |||||
Ali | 28/04/22 | 208 | North | |||||
Ali | 13/04/22 | 625 | North | |||||
Ali | 19/08/22 | 382 | North | |||||
Ali | 11/02/21 | 229 | North | |||||
Ali | 31/08/21 | 227 | North | |||||
Ali | 03/10/21 | 358 | North | |||||
Ali | 05/05/22 | 619 | North | |||||
Linda | 27/06/21 | 799 | South | |||||
Linda | 28/07/21 | 156 | South | |||||
Linda | 15/06/22 | 733 | South | |||||
Linda | 24/04/22 | 815 | South | |||||
Linda | 07/02/21 | 995 | South | |||||
Linda | 19/07/22 | 613 | South | |||||
Linda | 27/08/21 | 353 | South | |||||
Linda | 21/07/21 | 573 | South | |||||
Linda | 23/03/21 | 269 | South | |||||
Linda | 16/05/22 | 163 | South | |||||
Linda | 05/06/21 | 944 | South | |||||
Linda | 29/08/21 | 944 | South | |||||
Linda | 01/01/22 | 985 | South | |||||
Sam | 20/08/22 | 512 | West | |||||
Sam | 12/11/22 | 888 | West | |||||
Sam | 13/03/22 | 133 | West | |||||
Sam | 04/10/21 | 100 | West | |||||
Sam | 18/01/22 | 891 | West | |||||
Sam | 26/08/21 | 397 | West | |||||
Sam | 07/02/21 | 312 | West | |||||
Sam | 28/08/22 | 669 | West | |||||
Sam | 19/10/21 | 261 | West | |||||
Sam | 14/02/22 | 255 | West | |||||
Sam | 05/03/21 | 961 | West | |||||
Sam | 02/03/22 | 174 | West | |||||
Mike | 02/04/22 | 801 | North | |||||
Mike | 07/02/22 | 464 | North | |||||
Mike | 24/12/21 | 780 | North | |||||
Mike | 27/09/21 | 713 | North | |||||
Mike | 29/06/22 | 658 | North | |||||
Mike | 27/03/21 | 449 | North | |||||
Mike | 10/03/22 | 559 | North | |||||
Mike | 07/12/22 | 893 | North | |||||
Mike | 30/12/21 | 183 | North | |||||
Mike | 10/07/22 | 831 | North | |||||
Mike | 01/10/21 | 602 | North | |||||
Alexander | 07/01/21 | 800 | South | |||||
Alexander | 22/12/21 | 300 | South | |||||
Alexander | 25/08/22 | 600 | South | |||||
Alexander | 29/03/22 | 990 | South | |||||
Alexander | 10/07/22 | 876 | South | |||||
Alexander | 04/02/22 | 123 | South | |||||
Alexander | 03/09/22 | 854 | South | |||||
Alexander | 31/10/22 | 100 | South | |||||
Alexander | 27/08/21 | 300 | South | |||||
Alexander | 06/08/21 | 700 | South | |||||