Output: Reshapes your dataset to include a
ProdId column and new columns for each distinct value in the
Dates column. Each distinct
ProdId value is represented by a separate row in the reshaped dataset. Within each row, the new columns contain a sum of sales for the product for each date in the dataset.
pivot col:column_ref value: FUNCTION(arg1,arg2) [group: group_col] [limit:int_num]