Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
Can any one help me
'By default i want to select last three months from month field'
Thanks in advance
Try in any document with a listbox. Select three values from month listbox, and click on "Lock" in the toolbar. Do as many selections as you want: the value locked will never change, and will not be cleared. This usually is marked in blue, as selections are in green. regards. siva
You want it to be selected by default when any user enters the document or are you talking about one specific graph?
sum({<date={">=$(=Addmonths(makedate(max(year),max(month)),-3))"},month=, year=>}sales)
PFA