IPivotTableBucketProps

IPivotTableBucketProps.columnsproperty

Specify one or more attributes to create table columns from.

columns?: AttributesOrPlaceholders;

Remarks

There will be a column for each combination of the specified attribute’s values.

Note: you can specify column attributes in conjunction with one or more measures. In that case the table will contain column for each combination of attribute values & measures.

IPivotTableBucketProps.filtersproperty

Specify filters to apply on the data to chart.

filters?: NullableFiltersOrPlaceholders;

IPivotTableBucketProps.measuresproperty

Specify measures to create table columns from.

measures?: AttributesMeasuresOrPlaceholders;

IPivotTableBucketProps.placeholdersResolutionContextproperty

Optional resolution context for composed placeholders.

placeholdersResolutionContext?: any;

IPivotTableBucketProps.rowsproperty

Specify attributes, whose elements will be used to populate table rows.

rows?: AttributesOrPlaceholders;

IPivotTableBucketProps.sortByproperty

Specify how to sort the data to chart.

sortBy?: SortsOrPlaceholders;

IPivotTableBucketProps.totalsproperty

Specify what totals should be calculated and included in the table.

totals?: TotalsOrPlaceholders;

Remarks

Note: table can only render column subtotal and/or grand-totals. It is not possible to calculate row totals. Also note: the table will only include subtotals when in grouping mode and the grouping is effective = table is sorted by the first row attribute.