Creates a pivot table with the given number of columns and rows
Settings
Creates a pivot table with the given number of columns and rows
Examples
Task and Settings | Result |
|---|
Given a list of work records with employee and duration in minutes | 
|
Pivot table classify duration in - >15 min
- >30 min
- >1 h
- >2 h
- >3 h
- >4 h
- >1 d (8 h = 1 d workday)
- >2 d
- >3 d
- >5 d (5 d = 1 w workweek)
INTERVAL(1-15;16-30;31-60;61-120;121-180;181-240;
241-480;481-960;961-1440;1441-2400;2401-9999999) 
| 
|
Task and Setting | Result |
|---|
The range of observations will be classified in the specified number of equally large intervals. Set the Number of columns to 5 
| 
|
Troubleshooting
Problem | Frequent Cause | Solutions |
|---|
Columns are not sorted in the correct order | The pivot table sorts columns according to how the data appear in the original table. | Re-order the data in the original table. |
