DriveWorks Pro 15: SppSumTableColumnByGroup [send feedback...]

SppSumTableColumnByGroup

Returns a two column table showing distinct values in the first column, and summed data in the second.

Syntax

SppSumTableColumnByGroup([Table Array],[Group By Column],[Column To Sum])

Where:

Table Array is a table array (such as the data in a standard table, or the result of a QueryDataValues function.

Group By Column is the column in the table array that will be grouped.

Column To Sum is the column in the table array that will be summed for each unique value in the Group By Column.

Examples

RuleMeaning
SppSumTableColumnByGroup(DWLookupMaterialCost,3,4)Will return an array showing distinct values from the third column and summed data from the fourth column.

Table of Contents