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 |
|
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 |