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
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.