Documentation User Guide Operations / Node Formulas ROLLUP ROLLUP Basic OverviewDescriptionRolls 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])ParametersNode: 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 toSee also: Aggregation SettingsExamplesInput node Quantity describes quantity of products sold across time and categories.DimensionProductTimeValueDimension LevelsProduct GroupProductYearMonthLevel ValuesCarsModel T20182018-01112018-035MotorcyclesV-Twin20192019-027101 Scout20192019-0119Following examples describe Rolling up with different aggregation levels and aggregation functions. Rolling up with sum (default)ROLLUP('Quantity')=Value11 + 5 + 7 + 19 = 42Rolling up with averageROLLUP('Quantity', "AVG")=Value(11 + 5 + 7 + 19) / 4= 10.5Rolling up to year and product group dimension levels with sumUsing the pairs of dimension and level names Time-Year and Product-Product Group. ROLLUP('Quantity', "Time", "Year", "Product", "Product Group")=Product GroupYearValueCars201811 + 5 = 16Motorcycles20197 + 19 = 26 FAQsFrequently asked questions can be found here. Contact You may contact the Valsight Customer Support via:+49 30 46799042support@valsight.comAvailability: Mon-Fri *, 9 AM to 5 PM (Berlin, Germany) .*Except Public holidays in Berlin, Germany. ×