# Small order measure

**URL:** <https://pug.phocassoftware.com/t/small-order-measure/1714>\
**Category:** Ask the Community\
**Created:** [September 17, 2020, 5:21pm UTC](https://pug.phocassoftware.com/t/small-order-measure/1714 "2020-09-17T17:21:19Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dedmons](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/dedmons/32/664_2.png) [@dedmons](https://pug.phocassoftware.com/u/dedmons)\
**Post date:** [September 17, 2020, 5:21pm UTC](https://pug.phocassoftware.com/t/small-order-measure/1714/1 "2020-09-17T17:21:19Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![kstevens1](https://avatars.discourse-cdn.com/v4/letter/k/dfb087/32.png) [@kstevens1](https://pug.phocassoftware.com/u/kstevens1)\
**Post date:** [September 22, 2020, 11:03pm UTC](https://pug.phocassoftware.com/t/small-order-measure/1714/2 "2020-09-22T23:03:15Z")

</div>

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.

![image](https://us1.discourse-cdn.com/flex015/uploads/phocassoftware/original/1X/aa52d431a4ce34afca89e8b3b30316c0f1ff7063.png)