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! Click here to watch and learn more!
Update your Profile with your Support type to get your Support Type badge.
Expand your NetSuite knowledge by joining our Ask A Guru Live sessions. RSVP on this event now.
Community Poll: What sort of content would you like to see more of?
Get ready to take on exciting new challenges and become the next SuiteMaster of the Month!

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

Community Whiz

Quarter 3 (Jul-Sep 2024)

This Week's Leaders

This Month's Leaders

All Time Leaders