last 4 date data

[inam]

Hello Community,

1) I have raw data 1 to 24 July   i want only last 4 date data 24,23,22,21. if the today date is 26 so my data is 25,24,23,22 and in Total i want  month start to today total data 

2) i am using pivot table and i want to solve this in expression.

in Date Created i used below logic but not getting answer

& in expression tab  i used below expression

[inam]

Hello @BrunPierre Thanks for the help

my qvw 1 column is Report please select TCIL and than apply the logic .....i try your logic now but getting same problem .....if you select TCIL in Tcil  JULY data available till date ... so i want last 4 date data and total(MTD achived) is 1st july to 25th july