Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
SUM of items within a group
Hi there,
From the table of results below i am trying to calculate the total number of items within the groups included, for example. I need to get to the result of 8+4 =12 within a saved search summary.
| Name | Group | item | No. of items in group | Quantity Sold |
| Customer1 | Prod1 | Item1 | 8 | 1 |
| Customer1 | Prod1 | Item2 | 8 | 1 |
| Customer1 | Prod1 | Item3 | 8 | 1 |
| Customer1 | Prod1 | Item4 | 8 | 1 |
| Customer1 | Prod2 | Item1 | 4 | 1 |
| Customer1 | Prod2 | Item2 | 4 | 1 |
| Customer1 | Prod2 | Item3 | 4 | 1 |
Summary of results would include:
| Name | No. of Items in group | Quantity Sold |
| Customer1 | 12 | 7 |
Any help appreciated with this
Thanks
Tagged:
0