This image shows a results set containing columns Brand and Revenue, with an alternative to using CASE is to use a filter expression: FILTER(Revenue using Product_Type != ‘Camera’).
