Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Something like this: if(dimensionality()=0,max(Value1),'')
Something like this: if(dimensionality()=0,max(Value1),'')
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.