Search results

ToolbarItems API in React Pivot Table API component

Allows the built-in toolbar options that used to access features like switching between pivot table and pivot chart, changing chart types, conditional formatting, number formatting, exporting, etc… with ease at runtime. The available toolbar options are:

  • New - Allows to create a new report.
  • Save - Allows to save the current report.
  • Save As - Allows to perform save as the current report.
  • Rename - Allows to rename the current report.
  • Remove - Allows to delete the current report.
  • Load - Allows to load any report from the report list.
  • Grid - Allows to show the pivot table.
  • Chart - Allows to show the pivot chart with specific type from the built-in list.
  • Exporting - Allow set of options to export the pivot table as PDF/Excel/CSV and the pivot chart as PDF and image format such as PNG, JPEG, SVG.
  • Sub-total - Allow set of options to show or hide the sub totals in the pivot table. The subtotals will not be displayed in the pivot chart by default.
  • Grand Total - Allow set of options to show or hides the grand totals in the pivot table. By default, the grand totals will not be displayed in the pivot chart.
  • Conditional Formatting - Allows to show the conditional formatting pop-up to apply formatting to the values.
  • Number Formatting - Allows to show the number formatting pop-up to apply number formatting to the values.
  • Formatting - Allow options to show the conditional formatting and the number formatting pop-up that used to apply formatting to the values in the component.
  • Field List - Allows you to show the field list pop-up. It allows you to modify the report with a variety of actions such as re-arrange the fields between axes by drag-and-drop, add new fields to report, remove any fields from report, filtering and sorting a specific field members, etc., that are used to update the pivot table during runtime.
  • MDX - Allows to show the MDX query that was run to retrieve data from the OLAP data source. Note: It is applicable only for OLAP data source.