In my scenario, I need to get sum of Total_Orders group by supplier_name. And at the same time, I need to calculate how much percent in total does this sum of Total_Orders cover for each supplier_name dimension. Can you please help how to achieve.
I am using snowflake database.
The above case when it is written in sql it should act like
select supplier_name,sum(order_total),sum(order_total)/(select sum(order_total) from orders) as order_total_percent from orders group by supplier_name;
But I am not able to get the same scenario in looker. Please help.