Straight Table Hide Rows but Show Totals and Subtotals

[#1]

Is there an easy way to hide row values but display the total in a Straight Table?

Example, I want to change this:

Name     Value1  Value2

Joe           1         4

Sally         1         3

Fred         1         4

Total        1        11

To this Result:

Name Value1   Value2

Joe                      4

Sally                    3

Fred                    4

Total          1            11

[Gysbert_Wassenaar · Accepted solution]

Something like this: if(dimensionality()=0,max(Value1),'')

[#3]

For most expressions this would work:  Make a straight table with no dimension. There will be only one row.

If your original straight table had calculated dimensions and/or totals that are sum of rows totals then this method may not work for you.

I've seen people make the straight table as small as possible by sliding up the lower boundary and then covering up the unwanted portion with an opaque text box.