Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Can you post an image of the table?
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)?
Hi,
Had you try with count(total Field)?
That returns 12 (in your case) in every row.
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.
Try this:
if(dimensionality()=0, count(total Field), ' ')
Works great thank you!