Skip to main content
Skip table of contents

ROLLUP

Basic Overview

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

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.