Row level and Column level calculations - rowlevel() and collevel()

[Cloud release: 2025.01.15]
[On-prem release: 2025 January]
[On-prem build: 25.02.07520] 

Can be used to identify specific row levels and specific column levels in objects with multi-level hierarchies.

Returns an integer value [0, 1, 2, 3 ...] according to the level of the hierarchy where the cell value is calculated.

Syntax:

rowlevel()

Rowlevel() only makes sense to add "as a column" or "as a measure".

collevel()

Collevel() only makes sense to add "as a row" or "as a measure".

Examples:

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.