Skip to main content
Skip table of contents

DROPLEVEL

Basic Overview

Description

Removes one or multiple levels from the input. All finer levels on the same hierarchy are also removed (e.g. Month and Day will be removed if you remove the level Quarter).

Syntax

DROPLEVEL(Node, Level1[ ,Level2, ...] [AggregationType])

Parameter

  • Node: Input node, specified using the node name in single quotes (e.g. 'Profit')

  • Level: Name of the Dimension Level that should be removed from the output

  • AggregationType: Learn more about Aggregation Settings

Example

The node contains the Month level. The time dimension contains the DayMonthQuarter and Year levels. Learn more: Hierarchy & Dimension Management

Input Revenue =

Month

Product

Revenue

2019-01

A

57

2019-01

B

38

2019-02

A

68

2019-02

B

76

Output DROPLEVEL('Revenue', "Month") =

Year

Product

Revenue

2019

A

57 + 68 = 125

2019

B

38 + 76 = 114

Output DROPLEVEL('Revenue', "Product") =

Month

Value

2019-01

57 + 38 = 95

2019-02

68 + 76 = 144

Additional Hints

By combining the DROPLEVEL() and EXPAND() functions, you can get the days in a month very easily. Further information on the functionalities of combined operations can be found here.


Contact

You may contact the Valsight Customer Support via:

+49 30 46799042

support@valsight.com

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

*Except Public holidays in Berlin, Germany.


JavaScript errors detected

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

If this problem persists, please contact our support.