3 Replies Latest reply on Mar 15, 2018 12:09 PM by Jim Dehner

    IF THEN Statement with Dimension, Measure Grouping

    Josh Delekta

      Hello,

       

      Please see attached. I am trying to accomplish the following:

       

      1) If the company has spent more than $100,000 then show the Company Name

      2) If the company has spent less than $100,000 then group into "Other"

       

      The data would look something like:

       

      Company A - $200,000

      Company B - $300,000

      Other - $8,000,000

       

      I've tried but have been unsuccessful with:

       

      IF SUM([Amount])> 100000 THEN ATTR([Company Name])

      ELSEIF SUM([Amount])<= 100000 THEN "Less Than 100,000"

      END

       

      I'd also like to be able to add in filters potentially the will work with the Does anybody have any suggestions? Thank you.