Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
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