.I have a jqgrid configuration with three-level grouping and summary totals for revenue column.Â
It does well in terms of the desired grouping.
However, when it comes to summaries, only the two outermost level groupings are showing the correct sum total. The innermost group-levels are showing exactly the same summary value as the parent group-level when it shouldn’t.Â
For example,
Group A has a revenue total of $8,000,000;
Group A1 has $4,500,000;
Both Group A1.i and Group A1.ii both shows $4,500,000 (same as the parent level group) , when it should be $1,500,000 and $3,000,000 respectively adding up to the parents total. Â Â Â Â
-Same pattern for all third-level groupings.-
Â
I will appreciate all the help on this.
 Here is the code:
jQuery(“#48remote4”).jqGrid(
{
data: result.ReportLines,
datatype: “local”,
colNames:,
colModel:[
{
name:’LoB’,index:’LoB’, editable:true, align:”center”,sorttype:’text’, hidden:false
},
{
name:’Type’,index:’Type’, editable:true, align:”center”,sorttype:’text’, hidden:false, width:30
},
{
name:’AccountNumber’,index:’AccountNumber’, editable:true, align:”center”,sorttype:’text’
},
{
name:’ServiceCode’,index:’ServiceCode’, align:”center”, sortable:true, width:90
},
{
name:’NetRevenue01′,index:’NetRevenue01′,align:”right”,summaryType:’sum’, summaryTpl : ‘{0}‘,formatter:’currency’, width:70
}
],
rowNum:1000,
rowList:[100, 200, 500, 1000],
height: ‘auto’,
width: ‘auto’,
pager: ‘#p48remote4’,
sortname: ‘AccountNumber’,
viewrecords: false,
sortorder: “asc”,
caption:”Annual Revenue Report”,
grouping: true,
groupingView:
{
groupField : ,
groupColumnShow : [true, false, true],
hideFirstGroupCol:true,
groupText : ,
groupCollapse : true,
groupOrder: ,
groupDataSorted : true,
groupSummaryPos: ,
showSummaryOnHide: [true, true, true]
},
footerrow: true,
userDataOnFooter: trueÂ
}
Copyright 2014 TriRand LtdAll Rights ReservedRSS
Back to Top
