Total visible values, each column (as a row)

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

sum(0, all(v), 0)

• Sample crosstab:

Examples

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 < 100

Now one of the rows has been hidden, and that means that the built-in totals are wrong.

This is the perfect scenario to add the total that only includes visible rows - so now the totals are like this: