pivot_index
Creates a pivot table with indexed values.
Syntax
pivot_index(<dataTable>, <dataColumns>, <pivotColumns>)
| Parameter | Type | Description |
|---|---|---|
| dataTable | Table | The Datatable table. |
| dataColumns | Array | The Datacolumns value. |
| pivotColumns | Array | The Pivotcolumns value. |
Return values
Table
Usage
Creates a pivot table with order status as rows and total price as values.
pivot_index(orders, orders.status, orders.total_price)