7 Replies Latest reply on Nov 5, 2017 3:09 PM by Alexander Mou

    Sum sales when postal code is the same

    Nan Chen

      Hi guys,

       

      I just encountered one question. The question asks us to sum the sales for each individual postal code. For example, when the postal code is 32216 when need to sum all the sales with a postal code of this number.

       

      I was trying to use sum if but it says can not have one aggregated and one non-aggregated function. Anyone who knows how to do it?

       

      Thank you!