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
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