Skip to Content
avatar image
Former Member

Total Value in reports

Hi Experts,

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

by,

kart

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 04, 2008 at 03:52 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 02:36 PM

    for a quick use, goto the header colum and hold down ctrl key and left click, it will give you the total at the bottom

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 02:25 PM

    Hi Karthi,

    Do you mean you want add page total to this report for every page?

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded