DataTables logo DataTables

via Ad Packs
Groupby in Datatable using compute
  • ishamauryaishamaurya
    Posts: 2
    I have a datatable containing 3 columns and several rows eg
    table dtgroups
    Name Score1 Score 2
    A 10 20
    20 30
    C 10 20
    A 11 33
    B 11 10
    20 20
    B 11 10

    In the above table in column name i have A,B,C and " " rows.I want to use compute function get the result
    Name Score1 Score 2
    A 21 53
    B 22 20
    C 10 20
    31 40

    But i am unable to get the sum of score1 and score 2 for the row ""
    Can any one help me out?
  • koosvdkolkkoosvdkolk
    Posts: 123
    I would do this in (My)SQL, and not in Javascript. Do you happen to get the data from a database?

    In what form do you have your data before you make a DataTable with it?
  • ishamauryaishamaurya
    Posts: 2
    i am using vb.net
This discussion has been closed.
← All Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Support

Get useful and friendly help straight from the source.

Categories

In this Discussion