Skip to Content
0
Former Member
Nov 06, 2012 at 09:39 AM

Business Partners Analysis Report

731 Views

I need a query/report to show the following about a business partner....

  • Business Partner (selectable)
  • Business Partner Code
  • Total Sales Amount (£)
  • % of gross profit (overall)
  • Top 10 products purchased by this customer and the gross profit of each product

Is this possible to build this in the query generator ?

I have had some great help on queries on this forum so any guidance would be amazing.

Thanks