%META:TOPICPARENT{name="OATDOCIndex"}%
---+ pivot.js

Advanced interactive Pivot table.

%TOC%

---++ Objects

---+++ OAT.Pivot(div, chartDiv, filterDiv, headerRow, dataRows, headerRowIndexes, headerColIndexes, filterIndexes, dataColumnIndex, options)

Creates Pivot table. Arguments are explained below:

   * <tt>*div*</tt> - the pivot table will be created as a child of this element (dom element)
   * <tt>*chartDiv*</tt> - pivot chart will be created as a child of this element (dom element)
   * <tt>*filterDiv*</tt> - 'paging' selects will go here (dom element)
   * <tt>*headerRow*</tt> - array of headings for data <tt>Rows</tt> (array)
   * <tt>*dataRows*</tt> - array of rows. Every row (array) must have the same number of elements as <tt>headerRow</tt> (array of arrays)
   * <tt>*headerRowIndexes*</tt> - array, containing indexes of columns which should be drawn as vertical aggregate columns (array)
   * <tt>*headerColIndexes*</tt> - array, containing indexes of columns which should be drawn as horizontal aggregate columns (array)
   * <tt>*filterIndexes*</tt> - array, containing indexes of columns which should be drawn as paging aggregate columns (array)
   * <tt>*dataColumnIndex*</tt> - index of data column (number)
   * <tt>*optObj*</tt> - object containing following:
   * <tt>*headingBefore*</tt> - should we create headings before data? (bool)
   * <tt>*headingAfter*</tt> - should we create headings after data? (bool)
   * <tt>*agg*</tt> - constant, specifying appropriate aggregating function index (number)
   * <tt>*aggTotals* </tt>- constant, specifying appropriate aggregating function index for sub-totals and totals (number)
   * <tt>*showChart*</tt> - show chart? (bool)
   * <tt>*showRowChart*</tt> - show row totals chart? (bool)
   * <tt>*showColChart*</tt> - show column totals chart? (bool)
   * <tt>*type*</tt> - one of <tt>TYPE</tt> _constants for number formatting (OAT.PivotData)
   * <tt>*customType*</tt> - formatting function for TYPE_CUSTOM
   * <tt>*showEmpty*</tt> - show columns & rows with null values? (bool)
   * <tt>*subtotals*</tt> - show subtotals? (bool)
   * <tt>*totals*</tt> - show totals? (bool)
   * <tt>*currencySymbol*</tt> - when using <tt>OAT.PivotData.TYPE_CURRENCY</tt> as <tt>customType</tt> option. Default is $.

---++ Constants

---+++ OAT.PivotData.TYPE_

   * <tt><b>OAT.PivotData.TYPE_BASIC</b></tt> - 1234.56
   * <tt><b>OAT.PivotData.TYPE_PERCENT</b></tt> - 1234.56%
   * <tt><b>OAT.PivotData.TYPE_SCI</b></tt>- 1234E+02
   * <tt><b>OAT.PivotData.TYPE_SPACE</b></tt>- 1 234.56
   * <tt><b>OAT.PivotData.TYPE_CUSTOM</b></tt> - function in <tt>options.custom</tt> Type
   * <tt><b>OAT.PivotData.TYPE_COMMA</b></tt> - 1,234.56
   * <tt><b>OAT.PivotData.TYPE_CURRENCY</b></tt> (currency symbol in <tt>options.currencySymbol.$</tt> is default)

---++ CSS classes

---+++ .pivot_table

ToBeDone

---+++ .h1

ToBeDone

---+++ .h2

ToBeDone

---+++ .odd

ToBeDone

---+++ .even

ToBeDone

---+++ .subtotal

ToBeDone

---+++ .total

ToBeDone

---+++ .gtotal

ToBeDone

---+++ .pivot_chart

ToBeDone

---+++ .pivot row_chart

ToBeDone

---+++ .pivot col_chart

ToBeDone

---++ Example

<verbatim>
var pivot = new OAT.Pivot(div, chartDiv, filterDiv, headerRow, dataRows, 
                          headerRowIndexes, headerColIndexes, 
                          filterIndexes, dataColumnIndex, {}) 
</verbatim>

CategoryDocumentation CategoryOAT CategoryOpenSource CategoryToBeDone