SUMIFS in looker

[Oriol]

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