Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    28

    Unanswered: I want to add all the in count column and display it as grand total?

    I am having the report like this
    Reg code Cntry code Count
    -------- ---------- ------
    AF AO 177
    AF BF 56
    AF BI 8
    AF BJ 78
    AF BW 282
    AF CD 323
    AF CF 53
    AF CG 136
    AF CI 410
    AF CM 292
    AF CV 8
    AF DJ 9
    AF ER 15

    but i want to display along with grand total

    Reg code Cntry code Count
    -------- ---------- ------
    AF AO 177
    AF BF 56
    AF BI 8
    AF BJ 78
    AF BW 282
    AF CD 323
    AF CF 53
    AF CG 136
    AF CI 410

    -----------
    Grand total
    -----------

    How to consolidate the count it?
    rgds
    calyan

  2. #2
    Join Date
    Jun 2002
    Location
    UK
    Posts
    525
    Use awk...

    awk 'NR > 2 {gtot+=$3; print $0}END {print "GrandTot="gtot}' yourFile

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •