Discussions
Check out Oracle NetSuite upcoming events and conferences here
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now!
RUN, DON’T WALK...Registration for #SuiteWorld 2022 is officially OPEN! This special early bird price won’t last long, so make sure you don’t miss out: https://lnkd.in/gGRN78A3
YOUR VOICE MATTERS! VOTE FOR OUR NEXT WEBINAR TOPIC NOW.
Click on this link for the poll.
Click on this link for the poll.
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