Grouping

• stranter

  Valued Member

  Points: 62

  More actions

  August 2, 2019 at 1:20 pm

  #3668253

  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

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  August 3, 2019 at 2:10 pm

  #3668486

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• drew.allen

  SSC Guru

  Points: 76944

  More actions

  August 5, 2019 at 2:56 pm

  #3668847

  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