Create Pivottable

From Documentation
Revision as of 09:31, 28 September 2017 by Hawk (talk | contribs) (→‎Manipulation)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

With a PivotModel, we can easily create a Pivottable component.

Create a Pivottable

Given a PivotModel, creating a Pivottable is as simple as

<pivottable model="${model}" />


Grand totals

You can show or hide grand total rows or columns by specfiying

<pivottable model="${model}" grandTotalForColumns="false" 
	grandTotalForRows="false" />

Default values are true.

Data orientation

Data orientation means how to arrange data when there are more than one data fields. For example, if we specify "Price" and "Mileage" as data field,

<pivottable model="${model}" dataOrient="column" />


ZKPivotEsn work pivot 24.png


<pivottable model="${model}" dataOrient="row" />

will give

ZKPivotEsn work pivot 22.png


Title Cells

Pivottable can accept up to 3 child components, which will represent the 3 title cells in the order of data title, column title, and row title. For example,

<pivottable model="${model}">
	<div style="color: red">My Data Title</div>
	<div style="color: blue">My Column Title</div>
	<div style="color: green">My Row Title</div>

results in

ZKPivotEsn work pivot 26.png


As you have noticed, Pivottable has built-in paging support. Like Paging on Grid or Listbox, you can set page size and current page number. For example,

<!-- suppose model has Price, Mileage, Date as data field -->
<pivottable model="${model}" pageSize="10" dataOrient="row" />

ZKPivotEsn work pivot 32.png


  • Page size does not include the size of grand total rows.
  • Default page size is 20.


Users can interact with a Pivottable in the following way:

  • Open/close header nodes by clicking on the plus/minus sign on row and column fields.
  • Resize column width by dragging their edge.

Other actions are available through call Pivottable API and PivotModel API. The next section will introduce samples of wiring these API to the user interface.

Version History

Last Update : 2017/09/28

Version Date Content

Copyright © Potix Corporation. This article is licensed under GNU Free Documentation License.