Pivots the specified data into a table
Function:
Pivot_table(table = string, cols = list, rows = string, agg_group = drop down, new_table_name = string)
Parameters:
Table: Table name on which to perform function
Columns: Columns of the Pivot Table
Rows: Rows of the Pivot table
Value: How to aggregate the numeric data (sum, count, average, median, max, min)
New Table Name: Name of the Pivot Table
Examples:
Pivot_table(table = Budget, cols = ["Geo", "Segment"], rows = "Business Unit", agg_group = "sum", new_table_name = "Budget_Pivoted")