- A105959 is order number (i have 900 of them in my report)
- Product type column is the list of items that go into the order
- Each item is either aftermarket or equipment and has the unit price
we have other orders where the item price for aftersales is more than 50% of the total order value.
I have 900 orders, what would be the best way to categorize each order as equipment or aftersales based on 50% rule.
Hope to get some awesome responses!
27.3 KB Views: 282
27.8 KB Views: 7