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?