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 …
@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 …
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.