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?
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