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: GroupTeamMonthTotal KeysEmp w/ Keys% of Emp w/ KeysCustomer ServiceCallsJanuary10440Customer ServiceEmail January55100ProductionBranchJanuary331545ProductionOnlineJanuary5360 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.

Table with Groups and Sub-groups

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.

Reporting

Preparation

Accepted answers

DavidP

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.

report tool group data by month header.yxmd

All comments

ImadZidan

Hello @shanwar ,

This is an idea on how you can do it.

Hope it helps

GroupbyAndTable.yxmd

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.

report tool group data by month header.yxmd

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 🙂

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703