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:
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
Can you please share the way i can add the total column using Table Calculation. @Dawid
${quantity:total} * 2
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.
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
@Parin_Shah
Did you manage to solve the problem? I also wish for my column totals to be in the bottom row
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.
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.