Column Name

[inam]

Hello Community 

 i have data 1st july to 26 july so i want last 4 date data  23,24,25,26 ( if the date is 28 so i want 24,25,26,27 date data )  but i want MTD (Total) is 1st july to today date .

so i create the pivot table and in this table i am using expression below

in dimension

Expression below

expression formula :-

same as all [Date Created] only change -3,-2,-1   so its working fine but i want Actual date instead of name [Date Created] 

for example see below format 

Expected output

i want Actual date instead of  name [Date Created] .

[cristianj23a]

Hello, use this code.

Sum({< [Date Created] = {"$(=Date(Max([Date Created] )-1,'DD/MM/YYYY'))"} >} Sales)

Sum({< [Date Created] = {"$(=Date(Max([Date Created] )-2,'DD/MM/YYYY'))"} >} Sales)

In this code I am considering the previous day, if you want a day before the previous one, you just put -2 and so on.

For each formula you create a definition.

Regarts.

[marcus_sommer]

You need to use an expression for the labels, too. Just deriving the date-part from the set analysis condition - something like: date(now()-n)