Exporting with Grand Total row.

Looker Q&A Looker Studio
1
Show More

Whenever I export a table, I cannot export the Grand Total row. Does the export button support extracting the Grand Total?

Show More

Exported

Show More

ahmetcanozturk_1-1732784686836.png
ahmetcanozturk_1-1732784686836.png746×510 9.76 KB

My Looker studio table.

Show More

ahmetcanozturk_0-1732784630807.png
ahmetcanozturk_0-1732784630807.png1794×735 42.2 KB

2

Hi @ahmetcanozturk , thanks for your post!

It sounds like this might be a limitation of the Grand Total option. As a workaround, you can try adding a calculated field to the data source for the Grand Total. That should be able to be exported:

  • Go to your data source and add a new calculated field named “Grand Total”.

  • Within the calculation, use the appropriate function to sum up the relevant metric across all rows (e.g., SUM(Revenue)).

  • In your Looker Studio visualization, add this “Grand Total” field to the table or chart to display and export the total value.

1 Like
3

Thank you for your reply.

Unfortunately, the workaround solution doesn’t fully solve my problem. It added another column to the table.
However, I want to export the Grand Total to Sheets as a row, maintaining the current structure.