Hi there,
I want to understand how to do SUMIFS in Looker. Example of expression:
SUM “Value Column 1” when “Dimension 1” = “X” AND “Dimension 2” = “Y” AND “Dimension 3”=“Z”.
I’ve been trying calculated fields like the below but it hasn’t worked as it sums more rows than what it should:
if(${dimension 1}=${dimension column X} AND ${dimension 2}=${dimension column X}, sum(${column1}), ${column1})
Please let me know
Thanks
Oriol