How to get total as a column

Hi all. Could you help me please to understand if it is possible  to get totals as column using lookml?

I may create table calculation to have it (like on the screenshot below). But is it possible to create such field using lookML?

 

4fac4a55-fc1e-49a2-97b2-7e43c1b82396.png
0 1 161
1 REPLY 1

I think the Window function can be used to get the column totals.

SUM(${foo} OVER (PARTITION BY ...))

https://community.looker.com/technical-tips-tricks-1021/window-functions-in-looker-24298
Top Labels in this Space
Top Solution Authors