Grouping

  • 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:

    report

    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

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

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

  • 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