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

[BrunPierre]

Try with this

=Only({$<[Date Created]={">=$(=Date(Max([Date Created])-4,'DD-MM-YYYY'))<=$(=Date(Max([Date Created]),'DD-MM-YYYY'))"}>} [Date Created]))

[inam]

Hiii @BrunPierre Thanks for reply.

i tried your logic but not getting answer.

[BrunPierre]

My mistake, please try again.

=Aggr(Only({$<[Date Created]={">=$(=Date(Max([Date Created])-4,'DD-MM-YYYY'))<=$(=Date(Max([Date Created]),'DD-MM-YYYY'))"}>}[Date Created]), [Date Created])

[inam]

same not getting last 4 days date 

[BrunPierre]

Could you post the qvw or some data?

[inam]

i want last 4 days data and Total is 1st july to last date (25)

PFB qvw

[BrunPierre]

[Date Created] is not properly recognized, use this to interpret it.

Date#([Date Created], 'DD-MM-YYYYY') as [Date Created]

[inam]

Thanks @BrunPierre  for the help \

Date#([Date Created], 'DD-MM-YYYYY') as [Date Created] ...i try this but get ans ...how i solve this only i want last 4 date data and Total is month start to today date,....any other solution how i solve this ?

[BrunPierre]

=Aggr(Only({$<[Date Created]={">=$(=Date(Max([Date Created])-3))<=$(=Date(Max([Date Created])))"}>}[Date Created]), [Date Created])