X-Axis Column

System.Object

-

This column is used in the X-Axis calculation

-

Y-Axis Column

System.Object

-

This column is used in the Y-Axis calculation

-

Summation method

System.String

• Number
• Percentage column
• Percentage row

-

Select the method how rows and columns are summarized

-

Number of columns

System.String

-

Number of columns for the X axis:

• Enter the number of columns required
  • e.g. 3
• Using the STEP function (Interval;Minimum;Maximum)
  • The Minimum and Maximum parameters are optional
  • The separator = ;
  • Interval = Value range of a column
  • Minimum = Smallest value for column start
  • Maximum = Largest value for column end
  • e.g. STEP(35;5;250)
  • e.g. STEP(20)
• Using the INTERVAL function (From-To;......)
  • Free definition of column intervals. Any number of definitions are possible
  • The separator = ;
  • From = Interval start value
  • To = Interval end value
  • e.g. INTERVAL(17-34;68-211;)
  • e.g.  STEP(0-99)

-

Ignore NULL (X-Column)

System.Boolean

-

When activated all rows with invalid (NULL) values are ignored

-

Ignore 0 (X-Column)

System.Boolean

-

When activated all rows with the value 0 in column X are ignored

-

Number of rows

System.String

-

Enter the number of rows to be displayed

-

Ignore NULL (Y-Column)

System.Boolean

-

When activated all rows with invalid (NULL) values are ignored

-

Ignore 0 (Y-Column)

System.Boolean

-

When activated all rows with the value 0 in column Y are ignored

-

Hide totals row

System.Boolean

-

If this option is active, no totals row will be displayed in the pivot table

-

Given a list of work records with employee and duration in minutes

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.