Average hidden values, each column (as a row)

Niels Thomsen

January 07, 2026 10:37

Type: Inserted as a row
Description: Calculates the average of all hidden values in each column.
Range:
- Columns: Each column
- Rows: All rows (hidden)
- Measures: Each measure
Syntax:

avg(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

Set th condition to value < 200

Now two of the rows has been hidden based on this condition:

Adding average, hidden as a row will create this result (notice the average applies to total, each year and each measure):