Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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] .
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.
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)