Hi Everyone,
I am trying to sort the dates within a pivot table however it only sorts based on the first number of the date not the entire date. The cells are formatted as “date”, the data is coming from an SQL script and the date format is Australian so dd/mm/yyy.
Any ideas how to sort this would be much appreciated.
I am trying to sort the dates within a pivot table however it only sorts based on the first number of the date not the entire date. The cells are formatted as “date”, the data is coming from an SQL script and the date format is Australian so dd/mm/yyy.
Any ideas how to sort this would be much appreciated.