I have a peculiar requirement. I have some records with Arrival dates and planned Scheduled Dates. I need to create pivot showing quarter and teams in dimensions 1 and 2 respectively and Count on Tasks Arrived and Scheduled as expressions. The Issue I have is I cannot get all the 4 quarters in the Dimension as Q3 and Q4 have not started yet and also cannot get the data in expressions. I am attaching a Excel file with example. Any help appreciated.
