Skip to main content
The way to achieve your own success is the willingness to help somebody else. Go for it!
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