Displaying Grand Total

[Anonymous]

In this table: 

I have the total for revenue which is great but how can I also get the total number of companies to display as well, without changing their "Co" column? Seems the only to way to do so is to change the field from' don't summarize' to 'count', but once you do that there's just a 1 for all the ID's but I do get the grand total at the bottom. I also realize I can add the field again and just click count for that but I don't want to display a 'Count of Co' column with all 1's and a 'Co' column to see what the actual ID is. Thanks!

[PaulDBrown · Accepted solution]

@Anonymous

You can either create a new column with empty values except for the totals or create a "custom"  total in one of the existing columns. See the screenshot below:

 Or combine the techniques of course.

Hope that helps!

Regards,

Paul.

[Greg_Deckler]

So, you could create a measure to do the COUNT or DISTINCT of the companies, ad put it in it's own card visualization.

[Anonymous]

@Greg_Deckler I see. I've done that already but just didn't know if there was a way to have it in the table.

[Greg_Deckler]

I do not know of a way to do that in the way that you are describing. You could get fancy with the placement and formatting of your visuals to make it "look" that way. For example, if you set the background of your card visual to black, make it 0% transparent and bring it to the front then you could overlay it on top of the first column total row and cover up the "Total" and have it display the count in that cell. It would appear like it was in the table but it wouldn't be.