Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
hi,
Create DateNum field at script level.
eg: Num(Date) as DateNum,
and Use the below expression
Sum({<DateNum={$(=(Max(DateNum)-1))}>} Sales)
hi,
Create DateNum field at script level.
eg: Num(Date) as DateNum,
and Use the below expression
Sum({<DateNum={$(=(Max(DateNum)-1))}>} Sales)
Thanks