1 Reply Latest reply on Aug 6, 2013 11:02 PM by bill.cunningham

    Create bins with multiple line items

    Trent Baldac

      I want to build bins around transaction values, however in the data there can be multiple items in a transaction so I want to use the Total or SUM of the total transaction value as the condition ie. less than $5, $5 - $10, $10 -$15 etc. I have used a formula -


      [Sales Value] < 5 THEN "Less Than $5"


      [Sales Value] <= 10 THEN "$5-$10"


      [Sales Value] <= 15 THEN "$10-$15"




      However I believe this is looking at each individual line item rather than the total of the transaction, anyone have any ideas?