0

sort by sum

Jet Reports Historic Posts

January 06, 2014 10:26

None

Follow

Hello together,

i would like to create a list with all salespersons (listed in value entries) and sales amount (sum - descending). The list should be sort by column H (sales amount (actual) - descending). Should i insert a NL function in the NL function in D10?

Attached you find the Report.

Thanks in advance

• Sales Amount by customer salesperson.xlsx

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts January 06, 2014 17:43

  Hi Daniel,
  
  What you want here is a sort by sum, which can be implemented with a calculated filter field. Unfortunately, sorting this way can be pretty slow. However, you can speed up your current report significantly by replicating your rows from the Salesperson/Purchaser table and linking to the Value Entry instead of replicating from the Value Entry. You can also use Link= instead of NL(Filter) to perform your filter on the Customer table, which should be faster. Hopefully this will help offset the speed lost with doing the sort by sum. I am attaching your report with these changes. Does this help?
  
  Regards,
  Hughes

  • Copy of Sales Amount by customer salesperson - Modfied by Hughes.xlsx
• 0
  
  Jet Reports Historic Posts January 07, 2014 13:48

  Hi fhilton,
  
  thanks for your help. It was very helpful. I have only one question: If i want to analyse also the value entries with empty Salespers./Purch. Code, how should i change the formula?
  
  Thanks

• 0
  
  Jet Reports Historic Posts April 09, 2014 11:44

  Hi,
  
  i Need to sort the attached Report by sum per customer (3rd group). I inserted a -NL sum function in cell C12 and filtered with this cell in field G12 (Customer No.). It doesn't work! The Report has already a sorting by salesperson (see row 10). What is the reason for the value error in the customer line (row 12)
  
  Thanks.
  
  Kind regards

  • CUST003 Sales Amount by Salesperson and Item Type and Customer.xlsx