Selection formula help

[TimothyP]

I am trying to select purchase orders with multiple line items only. I do not want to report on the PO’s that only have one line item.

For example, when I group on PO the report looks something like this:

PO1
Line 1: Bread
Line 2: Butter
Line 3: Eggs

PO2
Line 1: Milk

PO3
Line 1: Pizza
Line 2: Soda
Line 3: Apples

PO4
Line 1: Orange Juice

PO5
Line 1: Water

I want my report to look like this

PO1
Line 1: Bread
Line 2: Butter
Line 3: Eggs

PO3
Line 1: Pizza
Line 2: Soda
Line 3: Apples

Any suggestions would be appreciated.

Thanks in advance for the knowledge,
Tim

 

[TimothyP]

My table looks something like this:

PO# Line# Item
PO1 1 Bread
PO1 2 Butter
PO1 3 Eggs
PO2 1 Milk
PO3 1 Pizza
PO3 2 Soda
PO3 3 Apples
PO4 1 Orange Juice
PO5 1 Water

Thanks,
Tim

 

[Naith]

Group on Product Order, as it seems you're currently doing.

In your Group Selection Criteria, enter:

Count({Line#},{PO#}) > 1

Naith