Table with Groups and Sub-groups

[shanwar]

Hi,

I badly need help on an output I'm trying to create using the Table tool under the Reporting palette. I need my final output to look like this:

Using this source table:

Group	Team	Month	Total Keys	Emp w/ Keys	% of Emp w/ Keys
Customer Service	Calls	January	10	4	40
Customer Service	Email	January	5	5	100
Production	Branch	January	33	15	45
Production	Online	January	5	3	60

Given the numerous examples in this community I was pretty sure my problem was less complicated and I could easily apply any of the given solutions, but I can't seem to find the right combination or setup.  Any leads or suggestions?

Thank you.

[ImadZidan]

Hello @shanwar ,

This is an idea on how you can do it.

Hope it helps

[DavidP]

Hi @shanwar 

My approach to removing the duplicate groups is slightly different from @ImadZidan's suggestion, but also uses a multi-row tool.

I also looked at how to put the month header at the top. Please see sample workflow attached.

I guess this has to scale to a larger dataset with multiple months? If so, please advise how you'd like this to work.

[shanwar]

Thank you both @ImadZidan and @DavidP!!!

Yes it will eventually cover the next 11 months, I was hoping to have the months extend to the right, while the Groups and Team expand downward (I still have a few more teams lined up)

Is that possible?

Apologies didn't made it clear, I was at wit's end when I posted the question.

[DavidP · Accepted solution]

Hi @shanwar 

I've modified the workflow to show 2 months of data. It should also work for more months as long as the input data structure is the same.

The months will be arranged alphabetically, so you might have to put a 01,02,03, etc. in front of them to get them in the right order.

[shanwar]

Hi @DavidP!

This looks great! Thank you so much!

You're right I just need to make some adjustments on the output for months, but that shouldn't be too hard.

Again thank you so much for putting up a sample and modified workflow!

[shanwar]

Thank you also @ImadZidan, I used your sample workflow on a similar data set but the output was the same as yours. 

Saved me probably hours to figure out 🙂