ROLLUP

ROLLUP

Description

Rolls up the given Node so it has no more than the given Levels left. ROLLUP(Node) will roll up that Node to a single measure.

Signature

 ROLLUP(Node, Dimension1, Level1, Dimension2, Level2, … , [AggregationType])

Parameters

  • Node: Input node, specified using the node name in single quotes (e.g. 'Profit')
  • Dimension1, Level1: Zero or more pairs of dimension and level names to roll up to
  • New in Version 1.17: New optional last parameter: "SUM" & "AVG" to overwrite the node's aggregation rule.
  • New in Version 1.18: You may use the new aggregation functions CLOSINGSUM and CLOSINGAVG

See also: Aggregation Settings

Examples

Input node Quantity  describes quantity of products sold across time and categories.

Dimension Product Time Value
Dimension Levels Product Group Product Year Month
Level Values Cars Model T 2018 2018-01 11
2018-03 5
Motorcycles V-Twin 2019 2019-02 7
101 Scout 2019 2019-01 19

Following examples describe Rolling up with different aggregation levels and aggregation functions. 

Rolling up with sum (default)

ROLLUP('Quantity')=

Value
11 + 5 + 7 + 19 = 42

Rolling up with average

ROLLUP('Quantity', "AVG")=

Value
(11 + 5 + 7 + 19) / 4= 10.5


Rolling up to year and product group dimension levels with sum

Using the pairs of dimension and level names Time-Year and Product-Product Group. 

ROLLUP('Quantity', "Time", "Year", "Product", "Product Group")=

Product Group Year Value
Cars 2018 11 + 5 = 16
Motorcycles 2019 7 + 19 = 26

Was this helpful?

Yes | Somewhat | No