Summary

Creates a pivot table with the given number of columns and rows

Please see Create Pivot Table V2

Want to learn more?

Settings

Creates a pivot table with the given number of columns and rows

Columns of input table

Parameter

Examples

Example 1: classify in pre-defined intervals

 

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)

 

 

 

Example 2: classify in a number of classes

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.

Related topics

  • ...