How can we use sumiif function in google data studio

Question

We use Sumiif in excel and Google Sheets need.

Please let me know what is the function that we can use in google data studio instead of sumiif

Regards, Girish

user_18097524 · Answer

in Google Data Studio you would need to use the CaseWhen. For example

SUM (Amount) WHERE (CASE WHEN Fruit = "Apple" AND Color = "Green" OR Color = "Red" ) then 1 else 0 END )