Description of CASE Best Practice Results 2

This image shows a results set containing columns Brand, Product Type, and Revenue Excluding Camera. By adding PRODUCT_TYPE to the report and using SUM, the results aggregate after the base level values are calculated.