6 Replies Latest reply: Aug 24, 2012 1:19 PM by amv34189

# How to get a sum row of a chosen dimension?

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?

• ###### Re: How to get a sum row of a chosen dimension?

Can you post an image of the table?

• ###### Re: How to get a sum row of a chosen dimension?

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)?

• ###### Re: How to get a sum row of a chosen dimension?

Hi,

Had you try with count(total Field)?

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

• ###### Re: How to get a sum row of a chosen dimension?

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.

• ###### Re: How to get a sum row of a chosen dimension?

Try this:

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

• ###### Re: How to get a sum row of a chosen dimension?

Works great thank you!