By using this website, you agree to our Terms of Use (click here)
Hi, I am trying to achieve sales for each agent. In this, I am joining SOOrder and SOLine to get the Total Sales and Total Orders for each agent by grouping CreatedByID. Since join is performed, I get multiple lines on SOOrder and when SUM is done on OrderTotal, it doesn't give the correct value.
Attaching the GI, I have created. Any help to get TotalSales would help
I'm with Ellie. Without context about your end objective, it's hard to provide advice. Can you help us understand what you want as an end result?
Data to display
Calculations required
Criteria and/or Parameters
Constraints and/or Filters
Sorting and Grouping