To add to this, I right clicked on the 'Total' row at the botton of the table - almost outside the regular data - and did a 'Hide' which hid it, but now I can't find how to get it back.

Thanks

Arjan, Louise - The Table View Summary Row is controlled from the Grouping drop down (Show overall summary row) and the function applied to each field is the Grouping function. Arjan - if you want two different functions applied, one for the row values and one for the Summary Row, you need to use Aggregation and set the aggregation function for the row values (unique count) and then use the Summary Row with the grouping function set to Sum, Mean, whatever.

I use the Aggregate and columns are set on Unique value count.
In the Grouping function there is no option however to select Sum, Mean etc.
Any ideas?

Is the field your are aggregating/grouping typed as Text, or Numeric (Integer or Decimal)? Normally, unique value count applies to Text/Categories...but these do not usually sum??

We will look at the file.

File is attached. Had to remove all views due to confidentiality.
Issue is that tablecells show unique value count of location ID's. Total row must show totals of all cells within the table

Arjan - Aggregation is an in-memory transformation of the data...once you apply aggregation and set the aggregation function applied to the fields as Unique value count, the underlying row values are not available for summing. When aggregating, you can either hide the Summary Row, set each column's grouping function to None, or possibly to Record count if the count of aggregated rows is meaningful in context.

Unfortunately, the same is true of Grouping...if you start by grouping the data and set the grouping function for cells to be Unique value count, you currently cannot specify a different function like Sum for the Summary Row.

You need to try two contiguous Table Views, or, if the number of cells is not too many, a custom formula-driven HTML table in the Content View.