RE: East Reports Question

I need to generate a list of the top 50 items purchased by our largest five customers, by quantity and revenue. I can’t seem to get it. Any assistance would be appreciated.
UCN Beginner Asked on December 3, 2021 in Reports.
Add Comment
3 Answers

I am not sure how to accomplish with saved search or canned reports.

Always you could dump a saved search to excel for a one time report and use pivot tables.

I would look into analytics and the pivot table function. I would start at a sales order data set with customer and line items in the data set.

Then make a picot table with customer as the rows. You can have one for revenue and one for item quantity for easier sorting.

 

 

 

Rookie Answered on December 6, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.