Creates a pivot table with the given number of columns and rows
| Parameter | Value | Opt. | Description | Example |
|---|
| X-Axis Column | System.Object | - | This column is used in the X-Axis calculation | - |
| Y-Axis Column | System.Object | - | This column is used in the Y-Axis calculation | - |
Parameter
| Parameter | Value | Opt. | Description | Example |
|---|
| Summation method | System.String - Number
- Percentage column
- Percentage row
| - | Select the method how rows and columns are summarized | - |
| Number of columns | System.String | - | Number of columns for the X axis:
| 1 | Enter the number of columns required e.g. 3 | | 2 | Using the STEP function (Interval;Minimum;Maximum) | | | The Minimum and Maximum parameters are optional.
The separator is a ; | | Interval | Value range of a column | | Minimum | Smallest value for column start | | Maximum | Largest value for column end |
| | E.g. | STEP(35;5;250) | | E.g. | STEP(20) | | 3 | Using the INTERVAL function (From-To;......) | | | Free definition of column intervals. Any number of definitions are possible
The separator is a ; | | From | Interval start value | | To | Interval end value |
| | E.g. | INTERVAL(17-34;68-211;) | | E.g. | STEP(0-99) |
| - |
| Ignore NULL (X-Column) | System.Boolean | - | When activated all rows with invalid (NULL) values are ignored | - |
| Ignore 0 (X-Column) | System.Boolean | - | When activated all rows with the value 0 in column X are ignored | - |
| Number of rows | System.String | - | Enter the number of rows to be displayed | - |
| Ignore NULL (Y-Column) | System.Boolean | - | When activated all rows with invalid (NULL) values are ignored | - |
| Ignore 0 (Y-Column) | System.Boolean | - | When activated all rows with the value 0 in column Y are ignored | - |
| Hide totals row | System.Boolean | - | If this option is active, no totals row will be displayed in the pivot table | - |
