GETMEASURE
The GETMEASURE function can be used to select data from a native measure based on its index. It should be used with an aggregate function like SUM or AVERAGE.
Syntax
GETCOLBETWEENPERIODS(index, type)Arguments
index– Order of the native measure in the AC/PY/PL/FC bucket. Required.
type– Can be AC/PY/PL or FC. Required.
Example
GETMEASURE(1, "AC")
//Returns the first native measure in the AC bucket
GETMEASURE(2, "PY")
//Returns the second native measure in the PY bucket