Total each column (as a row)

• Type: Inserted as a row
• Description: Calculates the sum of all values in each column, for each measure.
• Range:
  • Columns: Each column
  • Rows: All rows
  • Measures: Each measure
• Syntax:

sum(0, all, 0)

• Sample crosstab:

Examples

A standard TARGIT table already has a built-in row Total (see below)- so normally you won't need to calculate your own.

There are scenarios, however, where you will need to calculate a custom grand total.

One example of a use case where you would need to calculate a simple total is when you introduce a user dimension instead of a dimension.

Let's create our own user dimension to look at our sales people in a slightly different way.

Here's a user dimension where the 1st element is filtered down to Alvaro Bennett and Barret Forster and named Home Market....

...and the 2nd element is filtered by Fortunato Crawford, Luitpold Whyman and Vern Ferguson, and named International Market

Now the table looks like this - with no built-in grandtotal as a row (this is working as intended with user dimensions):

Add your prebuilt Total (row) calculation, and the table now has a grand total: