Last Record Value by Condition
Hi,
thank you for support.
To simplify, I have a fact Table A linked to the DATA Table.
| DATA | COD | TYPE | AMOUNT |
| 2024-11-20 | A | F | 0 |
| 2024-11-20 | A | G | 15 |
| 2024-10-02 | A | F | 10 |
| 2024-10-03 | B | G | 5 |
| 2024-10-01 | B | F | 1 |
I would like to get only the last value (ALL TIME) with TYPE = F and AMOUNT > 0, independently from the date selected in the filter menu :
| COD | LAST VALUE |
| A | 10 |
| B | 1 |
| TOTAL | 11 |
Thank you so much,
Alessandro
Last Record Value by ConditionYou must login to comment