Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
In my pivot table,i want to display max(date) sales in one column and previous month same date sales in one column.I tried alot,but i am not getting.
how to write the expresion for this two in set analysis.
can anyone help me.
regards,
baru
Hi,
the expression would look like for your max(date) like this:
sum({<Date = {'$(=(max(Date)))'}>}sales)
and for the previous:
sum({<Date = {'$(=(MakeDate(year(max(Date)),Month(Max(Date))-1,day(max(Date)))))'}>}sales)
hope this helps there might be some () missing cause I haven't tested it 😉
regards,
MT