3 Replies Latest reply on Nov 30, 2018 3:48 AM by Yuan Howe Liak

    Assigning a category based on a aggregate condition then counting members in category

    Yuan Howe Liak

      I have a table in this format:

       

      CustomerMonthSales
      A1947
      A2234
      A3423
      B1754
      B2355
      B3897

       

      And I would like to:

      1. Assign a category (call it Gold, Silver Bronze) to [Customer] based on the a conditional 'if' of the sum of all months filtered, then

      2. Have a table with each Category as row label and count([Category]) as the measure

       

      I feel like this should be simple to do but the inability to do something like 'if sum([Sales])>100000 then 'Gold' elseif sum([Sales]>50000 then 'Silver'...' is making me run into a wall..