looker column totals

[Parin_Shah]

I have a calculated filed in looker that is using table calculations based off another column.

When i select totals to get the column totals the calculated column total comes incorrect. I understand this is due to the reason mentioned here, but is there a way to get the correct total (using table calculations or some other element).

If i use the  sum(${view_name.field_name}) then i get a new column but what i need is a new row (total).

Example:

[Dawid]

You won’t be able to change the total row, those are pretty much “untouchable”. You would need to add another columns with a total of your Table Calculation - this is the way

[Parin_Shah]

Can you please share the way i can add the total column using Table Calculation. @Dawid 

[Dawid]

${quantity:total} * 2

[Parin_Shah]

But that would add another column for total and not a row at the bottom for total like so.

What i intend to have is a row at the bottom for total like so.

[Dawid]

That’s why I mentioned that changing the calculation for the “Totals” is impossible. You can perhaps try to create Custom Measure or even a new measure in the LookML, if you need the Totals to be correct

[diegooli]

@Parin_Shah 

Did you manage to solve the problem? I also wish for my column totals to be in the bottom row

[ddannar]

I would also like to have column totals on my chart columns at the bottom.  I have "Display Summary Totals", but I don't want all columns to have a total as it doesn't apply to all of them.

[ddannar]

Weird.  I have a column total row now, but it's at the top instead of the bottom.  I added a total row to linked google sheet at the bottom.