Summary

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

Please see Create pivot table 5.0


Configuration

Input settings of existing table

Settings

Want to learn more?

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