| rows |
array |
Each row grouping in the pivot table. |
| columns |
array |
Each column grouping in the pivot table. |
| values |
array |
A list of values to include in the pivot table. |
| criteria |
object |
An optional mapping of filters per source column offset. |
| filterSpecs |
array |
The filters applied to the source columns before aggregating data. |
| valueLayout |
string |
Whether values should be listed horizontally or vertically. |
| dataSourceId |
string |
The ID of the data source the pivot table is reading data from. |