Skip to main content
Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date / Quarter Issue in Pivot Table

Hi,

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