Skip to main content
Solved

Swing subtotals on Sales analysis report

  • 3 September 2020
  • 1 reply
  • 172 views

I have created a sales analysis query using sales analysis.

My query showing Customers - products - qty sold and amount of sales.

I am trying to make the report provide total per customer, I can see that when I collapse the customers but do not see the total when taking the report to excel, any one experience on solving this issue?

Best answer by hsarjapur

@dqaddo If your building a new report to show sales analysis based on invoices table then start out with a GI first, if you can group by the Customer AcctCD and also add a aggregate function SUM to each column that will summarize the total Qty and Amount per customer and once the GI works in the new version you can export the GI to a report and then you use the same schema and drag the fields to report … 

If you do need the details and summation then you need to use group header in reports and group the total qty or amount. Below is a GI that can give you some idea of sales analysis … 

Group by and also use aggregate function 

 

Hope this helps …

Harsha

View original
Did this topic help you find an answer to your question?

hsarjapur
Varsity I
Forum|alt.badge.img
  • Varsity I
  • September 10, 2020

@dqaddo If your building a new report to show sales analysis based on invoices table then start out with a GI first, if you can group by the Customer AcctCD and also add a aggregate function SUM to each column that will summarize the total Qty and Amount per customer and once the GI works in the new version you can export the GI to a report and then you use the same schema and drag the fields to report … 

If you do need the details and summation then you need to use group header in reports and group the total qty or amount. Below is a GI that can give you some idea of sales analysis … 

Group by and also use aggregate function 

 

Hope this helps …

Harsha


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings