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).
DROPLEVEL(Node, Level1[ ,Level2, ...] [AggregationType])
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
Input Revenue =
Output DROPLEVEL('Revenue', "Month") =
57 + 68 = 125
38 + 76 = 114
Output DROPLEVEL('Revenue', "Product") =
57 + 38 = 95
68 + 76 = 144
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.
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.
Please note, these errors can depend on your browser setup.
If this problem persists, please contact our support.