showRowTotals : Subtotals에 표시되는 %를 제대로 계산하고 싶습니다.
데이터에 왜곡이 생기고 있습니다.
row.변수는 먹히지 않네요...
답변 부탁드립니다.
소스는 아래와 같습니다.
verCdMon = verCdMon + Winter.lang('lbl.ame.curMonQty');
var billing = Winter.lang('lbl.ame.BillingQty');
// initialize pivot engine
var ng = new wjOlap.PivotEngine({
autoGenerateFields: false,
fields: [
{ binding: 'TEAM_CD', header: Winter.lang('lbl.ame.teamCode') },//팀코드
{ binding: 'TEAM_CODE_NAME', header: Winter.lang('lbl.ame.teamName') },//팀명
{ binding: 'PART_CD', header: Winter.lang('lbl.ame.partCd') },//파트코드
{ binding: 'PART_CODE_NAME', header: Winter.lang('lbl.ame.partName') },//파트명
{ binding: 'CUST_CD', header: Winter.lang('lbl.wnt.custCd') }, //고객코드
{ binding: 'CUST_NM', header: Winter.lang('lbl.wnt.custNm'), width: 150 }, //고객명
{ binding: 'PRD_CD', header: Winter.lang('lbl.ame.prdCd'), width: 150 }, //제품코드
{ binding: 'PROD_LVL_1_NM', header: Winter.lang('lbl.ame.ProdScmHrcy1') }, //대분류
{ binding: 'PROD_LVL_2_NM', header: Winter.lang('lbl.ame.ProdScmHrcy2') }, //중분류
{ binding: 'DSTRB_ROUT_CD', header: Winter.lang('lbl.ame.crclPathCd') }, //유통경로
{ binding: 'LAST_MON_QTY', header: Winter.lang('lbl.ame.lastMPfrslt'), aggregate: 'Sum', format: 'n2' }, //전월실적
{ binding: 'CURR_MON_QTY', header: verCdMon, aggregate: 'Sum', format: 'n2' }, //M월계획
{ binding: 'SALE_ORD_QTY', header: Winter.lang('lbl.ame.salesOrdQty'), aggregate: 'Sum', format: 'n2' }, //수주실적
{ binding: 'SHTS_QTY', header: Winter.lang('lbl.ame.shtsQty'), aggregate: 'Sum', format: 'n2' }, //적송실적
{ binding: 'BILLING_QTY', header: billing, aggregate: 'Sum', format: 'n2' }, //Billing실적
{ binding: 'SALE_ORD_QTY_RATE', header: Winter.lang('lbl.ame.salesOrdQtyRate'), aggregate: 'Sum', format: 'p2' }, //수주진척률
{ binding: 'SHTS_QTY_RATE', header: Winter.lang('lbl.ame.shtsQtyRate'), aggregate: 'Sum', format: 'p2' }, //적송진척률
{ header: Winter.lang('lbl.ame.BillingQtyRate'), format: 'p2', dataType:'Number',
getAggregateValue: row => row.verCdMon != 0 ? row.billing / row.verCdMon : 0
} //Billing진척률
],
itemsSource: rowData,
columnFields: [
],
filterFields: [
],
//'전월실적','M월계획','수주실적','적송실적','Billing'
valueFields: [
Winter.lang('lbl.ame.lastMPfrslt'), //전월실적
verCdMon, //M월계획
Winter.lang('lbl.ame.salesOrdQty'), //수주실적
Winter.lang('lbl.ame.shtsQty'), //적송실적
billing, //Billing실적
Winter.lang('lbl.ame.salesOrdQtyRate'), //수주실적
Winter.lang('lbl.ame.shtsQtyRate'), //적송실적
Winter.lang('lbl.ame.BillingQtyRate') //Billing실적
],
//'팀명','파트명',판매처,대분류,중분류,제품코드,유통경로
rowFields: [
Winter.lang('lbl.ame.teamName'),//팀명
Winter.lang('lbl.ame.partName'),//파트명
Winter.lang('lbl.wnt.custNm'), //고객명
Winter.lang('lbl.ame.ProdScmHrcy1'), //대분류
Winter.lang('lbl.ame.ProdScmHrcy2'), //중분류
Winter.lang('lbl.ame.prdCd'), //제품코드
],
showRowTotals: 'Subtotals',
showColumnTotals: 'None'
});