Group rows with different text

[jenner85]

How do I group data when the point I want to group on is different? For example i want to merge Workstations and Network onto one line, the unit values are the same, but they have two different rates that would need to add up. 

Owner	Cost Center	Service Type	Rate	Units	Total
Jen	500	Workstation	10	10	100
Jen	500	Network	10	10	100
Jen	500	VOIP	5	3	15
Jen	500	Landline	5	9	45

Owner	Cost Center	Service Type	Rate	Units	Total
Jen	500	Workstation + Network	20	10	200
Jen	500	VOIP	5	3	15
Jen	500	Landline	5	9	45

Thanks in advance!!

[Thableaus · Accepted solution]

Hi @jenner85 

here's a simple approach:

- Add a formula Tool to replace Workstation and Network values into a single one

- Use Summarize tool to bring the Sum of Rate, of Total and Max of Units

Flow attached.

Cheers,