Special functions

Special functions can be used in the data cell of the matrix. They allow you to get the value of another cell in the same row or column.

GrandColumnTotal

Returns the value of the grand total for the column.

Parameter	Description
aggregate	(optional) Aggregate function. Parameter can be omitted if the aggregate has already been accessed in the cell.

Examples:

GrandColumnTotal(Sum([MatrixDemo.Revenue]))
Sum([MatrixDemo.Revenue]) / GrandColumnTotal()

GrandRowTotal

Returns the value of the grand total for a row.

Parameter	Description
aggregate	(optional) Aggregate function. Parameter can be omitted if the aggregate has already been accessed in the cell.

Examples:

GrandRowTotal(Sum([MatrixDemo.Revenue]))
Sum([MatrixDemo.Revenue]) / GrandRowTotal()

GrandTotal

Returns the value of the grand total.

Parameter	Description
aggregate	(optional) Aggregate function. Parameter can be omitted if the aggregate has already been accessed in the cell.

Examples:

GrandTotal(Sum([MatrixDemo.Revenue]))
Sum([MatrixDemo.Revenue]) / GrandTotal()

ColumnTotal

Returns the value of the column total for the current group.

Parameter	Description
aggregate	(optional) Aggregate function. Parameter can be omitted if the aggregate has already been accessed in the cell.

Examples:

ColumnTotal(Sum([MatrixDemo.Revenue]))
Sum([MatrixDemo.Revenue]) / ColumnTotal()

RowTotal

Returns the value of the row total for the current group.

Parameter	Description
aggregate	(optional) Aggregate function. Parameter can be omitted if the aggregate has already been accessed in the cell.

Examples:

RowTotal(Sum([MatrixDemo.Revenue]))
Sum([MatrixDemo.Revenue]) / RowTotal()

ColumnMaxValue

Returns the maximum value of the column total for the current group.

Parameter	Description
aggregate	(optional) Aggregate function. Parameter can be omitted if the aggregate has already been accessed in the cell.

Examples:

ColumnMaxValue(Sum([MatrixDemo.Revenue]))
Sum([MatrixDemo.Revenue]) / ColumnMaxValue()

ColumnMinValue

Returns the minimum value of the column total for the current group.

Parameter	Description
aggregate	(optional) Aggregate function. Parameter can be omitted if the aggregate has already been accessed in the cell.

Examples:

ColumnMinValue(Sum([MatrixDemo.Revenue]))
Sum([MatrixDemo.Revenue]) / ColumnMinValue()

RowMaxValue

Returns the maximum value of the row total for the current group.

Parameter	Description
aggregate	(optional) Aggregate function. Parameter can be omitted if the aggregate has already been accessed in the cell.

Examples:

RowMaxValue(Sum([MatrixDemo.Revenue]))
Sum([MatrixDemo.Revenue]) / RowMaxValue()

RowMinValue

Returns the minimum value of the row total for the current group.

Parameter	Description
aggregate	(optional) Aggregate function. Parameter can be omitted if the aggregate has already been accessed in the cell.

Examples:

RowMinValue(Sum([MatrixDemo.Revenue]))
Sum([MatrixDemo.Revenue]) / RowMinValue()

FirstColumn

Returns the value of the first cell in the column.

Parameter	Description
aggregate	(optional) Aggregate function. Parameter can be omitted if the aggregate has already been accessed in the cell.
useInteractiveSort=false	(optional) Include the results of interactive sort, in which the order of the elements can be changed .
useThisGroup=true	(optional) Use a group at the same level to find a value.

The returned value depends on where the function is used:

• total cell: returns the value of the first cell in the group if parameter useThisGroup is true, otherwise it returns the value of the first total;
• group cell: returns the value of the first cell in the group.

Examples:

FirstColumn(Sum([MatrixDemo.Revenue]))
FirstColumn(Sum([MatrixDemo.Revenue]), true)
Sum([MatrixDemo.Revenue]) / FirstColumn()

FirstRow

Returns the value of the first cell in a row.

Parameter	Description
aggregate	(optional) Aggregate function. Parameter can be omitted if the aggregate has already been accessed in the cell.
useInteractiveSort=false	(optional) Include the results of interactive sort, in which the order of the elements can be changed.
useThisGroup=true	(optional) Use a group at the same level to find a value.

The returned value depends on where the function is used:

• total cell: returns the value of the first cell in the group if parameter useThisGroup is true, otherwise it returns the value of the first total;
• group cell: returns the value of the first cell in the group.

Examples:

FirstRow(Sum([MatrixDemo.Revenue]))
FirstRow(Sum([MatrixDemo.Revenue]), true)
Sum([MatrixDemo.Revenue]) / FirstRow()

LastColumn

Returns the value of the last cell in the column.

Parameter	Description
aggregate	(optional) Aggregate function. Parameter can be omitted if the aggregate has already been accessed in the cell.
useInteractiveSort=false	(optional) Include the results of interactive sort, in which the order of the elements can be changed.
useThisGroup=true	(optional) Use a group at the same level to find a value.

The returned value depends on where the function is used:

• total cell: returns the value of the last cell in the group if parameter useThisGroup is true, otherwise it returns the value of the last total;
• group cell: returns the value of the last cell in the group.

Examples:

LastColumn(Sum([MatrixDemo.Revenue]))
LastColumn(Sum([MatrixDemo.Revenue]), true)
Sum([MatrixDemo.Revenue]) / LastColumn()

LastRow

Returns the value of the last cell in a row.

Parameter	Description
aggregate	(optional) Aggregate function. Parameter can be omitted if the aggregate has already been accessed in the cell.
useInteractiveSort=false	(optional) Include the results of interactive sort, in which the order of the elements can be changed.
useThisGroup=true	(optional) Use a group at the same level to find a value.

The returned value depends on where the function is used:

• total cell: returns the value of the last cell in the group if parameter useThisGroup is true, otherwise it returns the value of the last total;
• group cell: returns the value of the last cell in the group.

Examples:

LastRow(Sum([MatrixDemo.Revenue]))
LastRow(Sum([MatrixDemo.Revenue]), true)
Sum([MatrixDemo.Revenue]) / LastRow()

PreviousColumn

Returns the value of the previous cell in the column.

Parameter	Description
aggregate	(optional) Aggregate function. Parameter can be omitted if the aggregate has already been accessed in the cell.
useInteractiveSort=false	(optional) Include the results of interactive sort, in which the order of the elements can be changed.
useThisGroup=true	(optional) Use a group at the same level to find a value.

The returned value depends on where the function is used:

• total cell: returns the value of the previous cell in the group if parameter useThisGroup is true, otherwise it returns the value of the previous total;
• group cell: returns the value of the previous cell in the group.

Examples:

PreviousColumn(Sum([MatrixDemo.Revenue]))
PreviousColumn(Sum([MatrixDemo.Revenue]), true)
Sum([MatrixDemo.Revenue]) / PreviousColumn()

PreviousRow

Returns the value of the previous cell in a row.

Parameter	Description
aggregate	(optional) Aggregate function. Parameter can be omitted if the aggregate has already been accessed in the cell.
useInteractiveSort=false	(optional) Include the results of interactive sort, in which the order of the elements can be changed.
useThisGroup=true	(optional) Use a group at the same level to find a value.

The returned value depends on where the function is used:

• total cell: returns the value of the previous cell in the group if parameter useThisGroup is true, otherwise it returns the value of the previous total;
• group cell: returns the value of the previous cell in the group.

Examples:

PreviousRow(Sum([MatrixDemo.Revenue]))
PreviousRow(Sum([MatrixDemo.Revenue]), true)
Sum([MatrixDemo.Revenue]) / PreviousRow()

NextColumn

Returns the value of the next cell in the column.

Parameter	Description
aggregate	(optional) Aggregate function. Parameter can be omitted if the aggregate has already been accessed in the cell.
useInteractiveSort=false	(optional) Include the results of interactive sort, in which the order of the elements can be changed.
useThisGroup=true	(optional) Use a group at the same level to find a value.

The returned value depends on where the function is used:

• total cell: returns the value of the next cell in the group if parameter useThisGroup is true, otherwise it returns the value of the next total;
• group cell: returns the value of the next cell in the group.

Examples:

NextColumn(Sum([MatrixDemo.Revenue]))
NextColumn(Sum([MatrixDemo.Revenue]), true)
Sum([MatrixDemo.Revenue]) / NextColumn()

NextRow

Returns the value of the next cell in a row.

Parameter	Description
aggregate	(optional) Aggregate function. Parameter can be omitted if the aggregate has already been accessed in the cell.
useInteractiveSort=false	(optional) Include the results of interactive sort, in which the order of the elements can be changed.
useThisGroup=true	(optional) Use a group at the same level to find a value.

The returned value depends on where the function is used:

• total cell: returns the value of the next cell in the group if parameter useThisGroup is true, otherwise it returns the value of the next total;
• group cell: returns the value of the next cell in the group.

Examples:

NextRow(Sum([MatrixDemo.Revenue]))
NextRow(Sum([MatrixDemo.Revenue]), true)
Sum([MatrixDemo.Revenue]) / NextRow()

SpecificColumn

Returns the value of the cell with the specified column index.

Parameter	Description
index	Index value
aggregate	(optional) Aggregate function. Parameter can be omitted if the aggregate has already been accessed in the cell.

The returned value depends on where the function is used:

• total cell: returns the value of the cell in the group of the total;
• otherwise, it returns the value of the cell in the column of the current group.

Examples:

SpecificColumn("Andrew Fuller", Sum([MatrixDemo.Revenue]))
SpecificColumn(2011, Sum([MatrixDemo.Revenue]))
Sum([MatrixDemo.Revenue]) / SpecificColumn(2011)

SpecificRow

Returns the value of the cell with the specified index in a row.

Parameter	Description
index	Index value
aggregate	(optional) Aggregate function. Parameter can be omitted if the aggregate has already been accessed in the cell.

The returned value depends on where the function is used:

• total cell: returns the value of the cell in the group of the total;
• otherwise, it returns the value of the cell in the row of the current group.

Examples:

SpecificRow("Andrew Fuller", Sum([MatrixDemo.Revenue]))
SpecificRow(2011, Sum([MatrixDemo.Revenue]))
Sum([MatrixDemo.Revenue]) / SpecificRow(2011)

PercentOfColumnTotal

Returns the value of the current cell divided by the value of the column total.

Parameter	Description
aggregate	(optional) Aggregate function. Parameter can be omitted if the aggregate has already been accessed in the cell.

Function call

PercentOfColumnTotal(Sum([MatrixDemo.Revenue]))

is equivalent to the following code:

Sum([MatrixDemo.Revenue]) / ColumnTotal()

Examples:

PercentOfColumnTotal(Sum([MatrixDemo.Revenue]))
[Sum([MatrixDemo.Revenue])] [PercentOfColumnTotal()]

PercentOfRowTotal

Returns the value of the current cell divided by the value of the row total.

Parameter	Description
aggregate	(optional) Aggregate function. Parameter can be omitted if the aggregate has already been accessed in the cell.

Examples:

PercentOfRowTotal(Sum([MatrixDemo.Revenue]))
[Sum([MatrixDemo.Revenue])]  [PercentOfRowTotal()]

PercentOfGrandTotal

Returns the value of the current cell divided by the value of the grand total.

Parameter	Description
aggregate	(optional) Aggregate function. Parameter can be omitted if the aggregate has already been accessed in the cell.

Examples:

PercentOfGrandTotal(Sum([MatrixDemo.Revenue]))
[Sum([MatrixDemo.Revenue])]  [PercentOfGrandTotal()]

PercentOfPreviousColumn

Returns the value of the current cell divided by the value of the previous cell in the column.

Parameter	Description
aggregate	(optional) Aggregate function. Parameter can be omitted if the aggregate has already been accessed in the cell.
useInteractiveSort=false	(optional) Include the results of interactive sort, in which the order of the elements can be changed .
useThisGroup=true	(optional) Use a group at the same level to find a value.

The returned value depends on where the function is used:

• total cell: the value of the previous cell in the group is used if parameter useThisGroup is true, otherwise the value of the previous total is used;
• group cell: the value of the previous cell in the group is used.

Examples:

PercentOfPreviousColumn(Sum([MatrixDemo.Revenue]))
PercentOfPreviousColumn(Sum([MatrixDemo.Revenue]), true)
[Sum([MatrixDemo.Revenue])]  [PercentOfPreviousColumn()]

PercentOfPreviousRow

Returns the value of the current cell divided by the value of the previous cell in a row.

Parameter	Description
aggregate	(optional) Aggregate function. Parameter can be omitted if the aggregate has already been accessed in the cell.
useInteractiveSort=false	(optional) Include the results of interactive sort, in which the order of the elements can be changed .
useThisGroup=true	(optional) Use a group at the same level to find a value.

The returned value depends on where the function is used:

• total cell: the value of the previous cell in the group is used if parameter useThisGroup is true, otherwise the value of the previous total is used;
• group cell: uses the value of the previous cell in the group.

Examples:

PercentOfPreviousRow(Sum([MatrixDemo.Revenue]))
PercentOfPreviousRow(Sum([MatrixDemo.Revenue]), true)
[Sum([MatrixDemo.Revenue])]  [PercentOfPreviousRow()]