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
