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