Total hidden values, each column (as a row)

Niels Thomsen

January 07, 2026 10:30

Type: Inserted as a row
Description: For each column and each measure, it will calculate the sum of all hidden rows.
Range:
- Columns: Each column
- Rows: All rows (hidden)
- Measures: Each measure
Syntax:

sum(0, all(h), 0)

In a standard crosstab, like the one above, you might choose to hide data based on value using a visibility agent.

Here, we choose to hide every salesperson who at some point had less than 100 Sales per year.

Choose properties, visibility agents, and pick Hide member

Now choose the measure No of Sales

Now one of the rows have been hidden - and we don't know how much is "missing" from the table.

We can now add a total, hidden row calculation (and disable the bulit-in total).