Hi everyone,
I have a query made with the following tables;
Price List Header, Price List Line,
Customer and
Item. I want to filter customer and item on the basis of unit price. Currently, the query outputs same combination of Item and Customer with different unit price. However, I want to show unique combination of Item and Customer. For the records having different unit prices for same Item-Customer combination, I want to filter such record based on lowest unit price.
For example:Right now, it outputs:
| Customer | Item | Unit Price |
| Customer1 | Item1 | 4 |
| Customer1 | Item1 | 5 |
| Customer2 | Item1 | 6 |
The result I want:
| Customer | Item | Unit Price |
| Customer1 | Item1 | 4 |
| Customer2 | Item1 | 6 |
I'd appreciate any help or suggestion. Thank you in advance.
