I have a multiprovider with 5 DSOs corresponding to 5 Logical SOurce systems.
All DSOs have a similar structure..like .....
Logical Source System, PO number , PO item, Material, quantity, price..........
In a query I wish to compare prices of a material for all logical source systems.
To reduce the number of rows,
I wish to exclude those materials which have just one PO across all 5 logical source systems.
Can you tell me how to exclude such rows with just 1 count?