Date & Time Ordering

To sort a pivot table by date and time:

Step 1. Add a column “Days in Calendar DateTime” by filtering Calendar DateTime by Days

Step 2: Add a column “Hours in Calendar DateTime” by filtering Calendar DateTime by Time>Every Hour