Forum Discussion
How Find Last price with supplier and item wise
My Data like bellow
I need to find last price with supplier wise and Item wise. How can I do it ?
| GRNNO | GRNDate | Supplier | Item | Price |
A1 | 2019/01/05 | Sup1 | Item1 | 100 |
| A2 | 2019/01/10 | Sup2 | Item2 | 150 |
| A3 | 2019/01/15 | Sup1 | Item1 | 120 |
| A3 | 2019/01/15 | Sup1 | Item4 | 200 |
| A4 | 2019/01/16 | Sup3 | Item4 | 130 |
| A5 | 2019/01/20 | Sup2 | Item2 | 135 |
No RepliesBe the first to reply