Table row is inserted in the wrong position

Question

I have a financials table where I have a function that is supposed to insert a subtotal row at the top of every parent. However I am doing something wrong as it actually inserts at the 2nd row within parent instead of the first.

Here is the function:

 $(document).ready(function() {
    $('.parent').parent().after('Sub Total');
  });

Here is my JSFiddle link that has my html and everything:

JSFiddle Link

Also can anyone point me in the right direction on getting the subtotals for the columns within each parent? I am getting the grand totals like this:

var sum = 0;

$('tr:not(:first):not(:last)').each(function () {
    sum += parseFloat($('td:eq(2)', $(this)).text());
});
$('#grandtotal').html(sum)

var sum1 = 0;

$('tr:not(:first):not(:last)').each(function () {
    sum1 += parseFloat($('td:eq(3)', $(this)).text());
});
$('#grandtotal1').html(sum1)

rphv · Accepted Answer

If you want the subtotal at the top of the group, use .before() instead of .after() - $('.parent').parent() selects the first of the group, which includes the first row of data.

As for calculating the subtotals, here's a strategy that uses the rowspan attribute on each . The rowspan value represents the number of rows in each group. This can be used to find the sub-sum of each column in the group:

$(document).ready(function() {
  $(".parent").each(function(index, element) {
    var subTotal1 = 0;
    var subTotal2 = 0;
    var subTotal3 = 0;
    var numRows = parseInt($(this).attr("rowspan"));
    var firstRow = $(this).parent();
    var currentRow = firstRow;
    for (i = 0; i < numRows; i++) {
      subTotal1 += parseInt($(currentRow.children(".child")[0]).text());
      subTotal2 += parseInt($(currentRow.children(".child")[1]).text());
      subTotal3 += parseInt($(currentRow.children(".child")[2]).text());
      currentRow = currentRow.next("tr");
    }
    firstRow.before('' +
      '' +
        'Group ' + (index + 1) + ' - Sub Total' +
        '' + subTotal1 + '' +
        '' + subTotal2 + '' +
        '' + subTotal3 + '' +
      '');
    $(this).remove();
  });
});

.table-style {
  width: 400px;
  font-size: 12px;
  color: #333;
  border-width: 1px;
  border-style: solid;
  border-color: #c0c0c0;
  border-collapse: collapse
}

.table-style th {
  border-width: 1px;
  padding: 5px;
  border-style: solid;
  border-color: #c0c0c0;
  background-color: #0000FF;
  color: #fff
}

.table-style tr:hover td {
  font-weight: bold
}

.table-style tr:nth-child(odd) td {
  background-color: #ADD8E6
}

.table-style td {
  border-width: 1px;
  padding: 5px;
  border-style: solid;
  border-color: #c0c0c0;
  background-color: #fff
}

.parent {
  vertical-align: top;
}



  
    
      Header0
      Header1
      Header2
      Header3
    
    
      Group 1
      23
      106040943
      117638617
    
    
      24
      20733153
      22164885
    
    
      25
      49086765
      53820000
    
    
      26
      30627906
      34237662
    
    
      27
      5408650
      5671224
    
    
      28
      2548936
      2647287
    
    
      29
      21911743
      22766661
    
    
      30
      15496867
      16387141
    
    
      31
      9897902
      9646904
    
    
      32
      23750440
      25845771
    
    
      33
      25213168
      27009243
    
    
      34
      71556982
      79796691
    
    
      35
      13464563
      16890000
    
    
      36
      9898131
      12360000
    
    
      Group 2
      21
      13111399
      11818156
    
    
      5
      68138406
      64295537
    
    
      58
      866778
      1245395
    
    
      6
      7969682
      8593771
    
    
      72
      127098852
      124284173
    
    
      77
      2806
      0
    
    
      85
      7350700
      6745754
    
    
      87
      96303976
      102006610
    
    
      Group 3
      10
      120112816
      126211000
    
    
      11
      66521923
      78090000
    
    
      12
      23696952
      25210000
    
    
      16
      126705761
      157886417
    
    
      3
      39672907
      39653000
    
    
      37
      9345911
      9634900
    
    
      56
      48397890
      49597217
    
    
      9
      110146281
      120303398
    
    
      Group 4
      14
      67824541
      70194836
    
    
      17
      42945336
      42390000
    
    
      18
      354189
      613560
    
    
      19
      36109243
      36188467
    
    
      20
      26278170
      26230825
    
    
      22
      40523406
      40209433
    
    
      67
      41648471
      39898784
    
    
      7
      103856047
      109500000
    
    
      71
      17248238
      15386522
    
    
      74
      67417236
      69046601
    
    
      Grand Total:
      
      1715284066
      1822116442

Table row is inserted in the wrong position

Answers (1)

Related Questions