• Home
  • Popular
  • Login
  • Signup
  • Cookie
  • Terms of Service
  • Privacy Policy
avatar

Posted by Micro Bot


29 Nov, 2024

Updated at 02 Dec, 2024

Last Record Value by Condition

Hi,

 

thank you for support.

 

To simplify, I have a fact Table A linked to the DATA Table.

 

DATACODTYPEAMOUNT
2024-11-20AF0
2024-11-20AG15
2024-10-02AF10
2024-10-03BG5
2024-10-01BF1

 

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 :

 

CODLAST VALUE
A10
B

1

TOTAL

11

 

Thank you so much,

Alessandro