Jump to content
Courtney

Report Layout Parts with differing levels

Recommended Posts

Courtney    0

Our current system organizes employees into Teams, and those Teams into Groups. Reports can then be run that display employee time with a sub-summary part for Group and one for Team to give a big picture into performance (see attached image example).

New management wants to split SOME but not all of those Teams into smaller functional areas. I'm trying to figure out what kind of layout and calculation gymnastics I'll need to do to display something like the example, but to add a third layer - only where a third layer exists.

So it might look something like this:
All Clinical Affairs
     Clinical Affairs
          Consulting
          Writing

     Clinical Strategy
     Program Management

I'm not sure if this is possible. I've been trying to make it work through different sorting or organizing the 3 fields (Group, Team, Function) differently, and I'm not having any success so far.

Any ideas? Or confirmation this is not possible, and I need to do something different?

Thank you!

~Courtney

 

OrgLayoutExample.png

Share this post


Link to post
Share on other sites
Fitch    148

Wouldn't another sub-summary do it?

Share this post


Link to post
Share on other sites
Courtney    0
49 minutes ago, Fitch said:

Wouldn't another sub-summary do it?

So, I'm feeling dumb today. I was trying to put data in every field of that third level, and I realize now that if I only put data on the third level where needed, that should solve my problem.

Short answer: yes, another sub-summary does appear to do it. :B

Share this post


Link to post
Share on other sites
Fitch    148

Glad you solved it!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


  • Who Viewed the Topic

    1 member has viewed this topic:
    dpwilton 
×

Important Information

By using this site, you agree to our Terms of Use.