I am not able to sort the pivot table by a date field (Finish Date).
I have tried:
1) click the column and select SORT (oldest to newest)
2) Added the date column to the VAlues (as a number), Click it and selected Sort
3) Added a new column that is the same for all rows, and then selected --> Sort --> More Sort Options --> Ascending by Finish Date
None of these worked for me. I know I am missing something basic.
I attached a simplified version (with slicer).
Any help would be appreciated !
Thank you,
John
Bookmarks