Hi there,
I'm sure many people have asked this question before me so please don't mind 🙂
Its a simple question:
I've presented data in pivot table. Table has team, ticket#, status (open/close), open date, close date & total tickets (expression).
From the forums I've created 2 fiscal calendars (1-start date & 2-end date) Now i want hook this calendar to the pivot table so that user can drive the data he wants to see in pivot table.In other words, when user selects
1) start date (single value)--> pivot table should show all open/close date for that day
2) start date (range)--> For eg: If user selects all open since last week then pivot table should show all open/close date for 2 weeks.
3) end date (single value & range) --> same as above.
4) start date (from date) and end date (to date) --> pivot table should show all tickets open/close for the given range.
appreciate your help in advance!
thanks!
