Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
i have one requirement..
if i am open my Application by default selections Maximum year(2015) and Previous month(Feb)
i have one chart using drill group...
Suppose i have Month-->Site-->Dept--->Use
By Default in my chart it should show months only
Thanks in Advance..
Go to
Settings
Document Properties
Document Event Triggers
OnOpen
AddActions
Fields
Cal_Date
Search String
='>='&MonthStart(Max(Cal_Date),-1)&'<='&MonthEnd(Max(Cal_Date),-1)