August 2, 2019 at 1:20 pm
Hi,
I'm trying to create a report (using a Dynamics 365 Fetch) of all completed bookings grouped by week number, day and account. So far, I've got this:
What I want is to group by week number, day name and account so that you expand the week number to reveal a list of accounts with bookings in that week, each of which can be expanded to reveal a list of days on which there were bookings which can be expanded to reveal the sites and duration, like this:
Week Number Account Site Duration
+ 31
+ 32
- 33 + Cust A
+ Cust B
- Cust C Park 34
Path 10
+34
Any idea how I can do this?
Thanks for any help!
Stewart
August 3, 2019 at 2:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
August 5, 2019 at 2:56 pm
Are you looking for a T-SQL solution or a Dynamics 365 solution? It's probably easiest to do it in Dynamics 365, but I am not at all familiar with that application. In T-SQL you would need to use GROUPING SETS()
.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply