Search results

SubTotalsPosition API in JavaScript (ES5) Pivot Table API control

Specifies different types of positions that will allow the row and column sub-totals to be displayed at the top or bottom of the header group in the pivot table. The available options are:

  • Auto - Defines the row and column sub-totals to be displayed in their default positions, i.e., the column sub-totals are displayed at the bottom and row sub-totals are displayed at the top of their header group in the pivot table.
  • Top - Defines the row and column sub-totals to be displayed at the top of the header group in the pivot table.
  • Bottom - Defines the row and column sub-totals to be displayed at the bottom of the header group in the pivot table.