Merging two summarized outputs in a nested fashion.

[knobsdog]

I have a list of data broken down by group and it's sub-channel which I've made generic with numbers for this purpose.  Each group and channel has it's time # in duration and I have created two workflows that show median duration for each group and each channel.  I need to bring them back together to show the group median and it's sub-channels with their median durations numbers under it.

Any idea how I can make it look like this?

Group	Median Total Duration
CTO	33.24
19	33.24
FCPS	43.80
5	36.99
7	44.10
9	55.78
13	47.81
17	42.35
20	42.87
FCPS-S	35.91
4	36.84
10	35.11
MSO	34.06
2	34.82
6	32.88
16	34.06
18	34.88
Other	27.59
3	35.91
11	27.59
S&L	24.90
1	28.06
8	29.03
15	15.89
ShSr	41.10
12	20.83
14	42.59

[Ladarthure · Accepted solution]

Hi @knobsdog,

I did a sample workflow, to achieve whatt you want, I used a multi row formula to be able to sort and created an order field and then unioned my data.

hope it helped!

[knobsdog]

That does work however is there a way to bold the group name and total so it stands out and doesn't get mixed in with the channel names and totals?

[Ladarthure]

This would be about using the reporting tools, where you can set rules per row, you can look at the report table tools which allow plenty of customization depending on your needs. You can then export to excel or event pdf with a render tool!

[knobsdog]

Makes sense, I'll explore that avenue.