Aggregate data based on a date-time column
Minimum Origin Version Required: Origin 2024
1. wtspivot -r 1 time:=[Book1]Sheet1!A data:=[Book1]Sheet1!A rows:=dayofmonth cols:=month method:=max;
Please refer to the page for additional option switches when accessing the x-function from script
Input
Range
int
Option list:
String
Output
ReportData
This X-Function allows you to create a pivot table to visualize data summarization (of statistics) based on a date-time column