This sample demonstrates the toolbar options of the pivot table. The options include report manipulations like create, save, save as, rename and delete, show or hide subtotals and grand totals, conditional formatting, and exporting in the pivot table and pivot chart.
In this example, users can generate a report at runtime, as well as save and load them. Save and load operations are performed in localStorage (session storage) using the saveReport and loadReport events. Users can change to either pivot table or pivot chart using the toolbar options. Other toolbar options available are: Create new report: Allows user to create new reports at runtime. Rename report: Allows user to change current report name dynamically through UI. Remove report: Allows user to remove current report from the report collection at runtime. Save as option: Allows user to save report locally in browser memory. Report list: Allows user to swap between the reports within the report collection. Pivot Table: Allows user to view data in cross-tabulation format. Pivot Chart and its types: Allows user to view data in graphical format. The chart types include column, bar, line, area, etc. It also has options for showing and hiding legends and displaying chart series of different measures on single and multiple axes. Export: Provides options to save data in PDF, Excel, and CSV document types. Hide subtotals and grand totals: Allows user to hide grand totals and subtotals (based on fields) in row and column. Conditional formatting: Allows user to customize cells base on certain conditions. Number formatting: Allows user to dynamically apply number formatting to value fields. Field List: Provides option to alter the report dynamically through UI.