pivot.js
Advanced interactive Pivot table.
Objects
Constants
- OAT.PivotData.TYPE_BASIC
- OAT.PivotData.TYPE_PERCENT
- OAT.PivotData.TYPE_SCI
- OAT.PivotData.TYPE_SPACE
- OAT.PivotData.TYPE_CUSTOM
CSS classes
- .pivot_table
- .h1
- .h2
- .odd
- .even
- .subtotal
- .total
- .gtotal
- .pivot_chart
- .pivot_row_chart
- .pivot_col_chart
Creates Pivot table. Arguments are explained below:
- div - table will be created as a child of this element
- chartDiv - pivot chart will be created as a child of this element
- filterDiv - 'paging' selects will go here
- headerRow - array of headings for dataRows
- dataRows - array of rows. Every row (array) must have the same number of elements as headerRow
- headerRowIndexes - array, containing indexes of columns which should be drawn as vertical aggregate columns
- headerColIndexes - array, containing indexes of columns which should be drawn as horizontal aggregate columns
- filterIndexes - array, containing indexes of columns which should be drawn as paging aggregate columns
- dataColumnIndex - index of data column
- optObj - object containing
- headingBefore - should we create headings before data?
- headingAfter - should we create headings after data?
- agg - constant, specifying appropriate aggregating function index
- aggTotals - constant, specifying appropriate aggregating function index for sub-totals and totals
- showChart - show chart?
- showRowChart - show row totals chart?
- showColChart - show column totals chart?
- type - one of TYPE_ constants for number formatting
- customType - formatting function for TYPE_CUSTOM
- showEmpty - show columns & rows with null values?
- subtotals - show subtotals?
- totals - show totals?