set analysis for previous day

[#1]

Hi,

the set analysis expression for the selected date in my chart is Sum({$<Date=P({$} tDate )>} Sales) , its working fine, I want another column with previous date to compare the sales.

Thanks in Advance...

[deepakk · Accepted solution]

hi,

Create DateNum field at script level.

eg: Num(Date) as DateNum,

and Use the below expression

Sum({<DateNum={$(=(Max(DateNum)-1))}>} Sales)

[#3]

Thanks