GROUPACCUMULATE

Syntax

GROUPACCUMULATE(<number or date>;<number>)

Description

Returns the sum of all previous records in a group.

This function requires a key column (GROUPBY) and two arguments. The first argument (OrderBy) is the column used for sorting the accumulated values. The second argument (number) is the column of values to be summed within their groups.

This is a group series function and only operates on columns from a data source or join sheet.

Example

Given the following data:

First create a group by the year using GROUPBY(YEAR(#RawData!Date))

Next copy the date column to your group using COPY(#RawData!Date)

Using GROUPACCUMULATE(#RawData!Date;#RawData!Revenue), Datameer returns the accumulated sum of all the records within each group.