pivot.js

pivot.js

Advanced interactive Pivot table.

Objects

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

Creates Pivot table. Arguments are explained below:

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

Constants

OAT.PivotData.TYPE_

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

CSS classes

.pivot_table

.h1

.h2

.odd

.even

.subtotal

.total

.gtotal

.pivot_chart

.pivot row_chart

.pivot col_chart

Example

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