Is there a way to create a measure that will pull just one to three line orders? We are looking for a way to find the orders that are coming across that are less than a certain line count? I can see total lines for an order but need to know those orders than are one to three lines.
In DB designer I created a measure called “Line Count”. Then you can then go into transaction mode and use advanced search for measures and line count less than 4. It will calculate and total transactions.