How to get a sum row of a chosen dimension?

[#1]

Hello,

When i create a straight table i usually use the simple expression Count(Field) so it adds a column to my straight table with a total number, but it also places a '1' next to every line. Is there a way to just get the total count in the first row and not all the 1's in every single line? Maybe a better expression or a way to remove the 1's?

[mazacini]

Can you post an image of the table?

[#3]

I still want that total number 12, but i don't want all of those 1's. Is there another way to take a total of a Company instead of adding an expression to the straight table of Count(Company)?

[Anonymous]

Hi,

Had you try with count(total Field)?

That returns 12 (in your case) in every row.

[#5]

I don't want numbers in every row. I just want one row with the total which is 12 in this case. All the other rows i want to be blank.

[Anonymous · Accepted solution]

Try this:

if(dimensionality()=0, count(total Field), ' ')

[#7]

Works great thank you!