Skip to main content
MAINTENANCE ALERT: Dec. 12th starting 9 AM CET. Community will be read-only. GET DETAILS
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date / Quarter Issue in Pivot Table


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.

Thanks to all in advance.

Note: I am still using version 8.2

0 Replies