Total Value in reports
Can any one help me how to get the Total sum of values and total qty in sales report that is particularly in the end of the report Ex: In Sales Analysis report total sum will be shown in end of the page. ...
Through : Query
Do you mean you want to total in queries? This being the case you can ctrol- double click on a column header to get a total. Alternatively you can add a field in the last column to sum which will give you a running total but as far as I know that is the only way in queries.
running total is as simple as sum(fieldname)
It will display on every line though