[OLAP] 前の行／列との比率

by Wijmo5_jp

HTML

<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">
<script src="https://demo.grapecity.com/wijmo/sample/scripts/sample.js"></script>
<link rel="stylesheet" href="https://cdn.grapecity.com/wijmo/5.latest/styles/wijmo.min.css">
<script src="https://cdn.grapecity.com/wijmo/5.latest/controls/wijmo.min.js"></script>
<script src="https://cdn.grapecity.com/wijmo/5.latest/controls/cultures/wijmo.culture.ja.min.js"></script>
<script src="https://cdn.grapecity.com/wijmo/5.latest/controls/wijmo.input.min.js"></script>
<script src="https://cdn.grapecity.com/wijmo/5.latest/controls/wijmo.grid.min.js"></script>
<script src="https://cdn.grapecity.com/wijmo/5.latest/controls/wijmo.grid.filter.min.js"></script>
<script src="https://cdn.grapecity.com/wijmo/5.latest/controls/wijmo.olap.min.js"></script>
<div class="container">

  <h1>前の行／列との比率</h1>
  <p>ShowAs列挙体のPctPrevRowとPctPrevColメンバーが追加され、前の行との比率、前の列との比率を表示できるようになりました。</p>
  <div id="pivotGrid"></div>

</div>

JavaScript

var engine = new wijmo.olap.PivotEngine({
  itemsSource: sample.ordersDetail(1000),
  fields: [
    { binding: '受注日', header: '受注日', format: 'EEEE年度' },
    { binding: '金額', header: '金額' },
    { binding: '金額', header: '前年度比', format: 'p' },
  ],
  rowFields: ['受注日'],
  valueFields: ['金額', '前年度比'],
});
engine.fields.getField('前年度比').showAs = 'PctPrevRow';
var pivotGrid = new wijmo.olap.PivotGrid('#pivotGrid', {
  itemsSource: engine
});