value of transaction
1 Topic
Find value of all transactions that have specific codes
I have a dataset of all sales order items using the format below. I would like to create a measure that returns the value of all orders that contain C1. It must include the values of all items on the order, not just C1. How would I go about this? OrderNo Code Qty Subtotal Ord1 C1 1 10.00 Ord1 C2 3 15.00 Ord2 C1 2 20.00 Ord2 C3 3 9.00 Ord 3 C2 4 20.00 Ord3 C3 1 3.00Solved570Views0likes1Comment