SOLVED
Group rows with different text
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
jenner85
8 - Asteroid
‎04-17-2019
07:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!!
Solved! Go to Solution.
Labels:
- Labels:
- Help
1 REPLY 1
17 - Castor
‎04-17-2019
07:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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,
