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.

SUM of items within a group

edited Jan 3, 2020 12:59AM in Search / Reporting 1 comment

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.
 
    
   
   
   
   
   
  
  
   
   
   
   
   
  
  
   
   
   
   
   
  
  
   
   
   
   
   
  
  
   
   
   
   
   
  
  
   
   
   
   
   
  
  
   
   
   
   
   
  
  
   
   
   
   
   
  
  

NameGroupitemNo. of items in groupQuantity Sold
Customer1Prod1Item181
Customer1Prod1Item281
Customer1Prod1Item381
Customer1Prod1Item481
Customer1Prod2Item141
Customer1Prod2Item241
Customer1Prod2Item341

Summary of results would include: 
    
   
   
   
  
  
   
   
   
  
  
NameNo. of Items in groupQuantity Sold
Customer1127

Any help appreciated with this

Thanks

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!

Leaderboard

This Week's Leaders

This Month's Leaders

All Time Leaders