It's possible to find the last registry by date field of a row in another table?
| name | price | date | invoice |
|---|---|---|---|
| PRODUCT A | 120 | 01/02/2023 | 1 |
| PRODUCT B | 90 | 15/01/2023 | 2 |
| PRODUCT A | 150 | 20/02/2023 | 1 |
INVOICE | No. Invoice | product | price | | --- | ------- | -------- | ----- | | 1 | PRODUCT A | 150 | | 2 | PRODUCT B | 90 |
what is desired is to filter only the last record and return the value that corresponds to it, the filter should be the most recent one.
I have tried with a rollup but it brings all the records associated to the same pipeline and only the most recent one is needed.
