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

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

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

ROLLUP('Quantity')=

Value
11 + 5 + 7 + 19 = 42

ROLLUP('Quantity', "AVG")=

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

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

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

Frequently asked questions can be found here.

You may contact the Valsight Customer Support via:

+49 30 46799042

Availability: Mon-Fri *, 9 AM to 5 PM (Berlin, Germany) .

_{*Except Public holidays in Berlin, Germany.}