Create Dynamic Pivot Table Chart (Version 4)
In many cases your reports will return multiple columns of data that you will want to scrutinize at different category levels on the fly.
Dynamic Pivot Table Charts allow you to quickly sort, filter and re-arrange chart data to meet your everyday requirements.
This article provides a step by step example of the process used to create a Dynamic Pivot Table Chart.
Additional documentation can be found at https://github.com/nicolaskruchten/pivottable
1. Choose an existing Report or create a new one
- In the report editor, select Report Content tab.
- Add a new Chart.
2. Enter Chart Definitions
- Select Report Result Set as the data to be charted.
- Choose Dynamic Pivot Table as the Chart type.
- Select Use Column Header Values as the X-axis value.
Save
3. Full Chart Editor Displays
- Enter a meaningful Name.
- Set X-axis definitions. Specify Use Column Header Values to return all columns.
- Set Y-axis definitions.
- Set Chart Content options.
4. Add any desired Chart Filters
- Navigate to the Chart Filters tab.
- Add New column filter.
4.1. Set any Filter selections
- Select Column.
- Choose Filter.
- Input Value.
Save
Note that this step is optional since the Dynamic Pivot Table Chart provides filtering capabilities.
