Default selection- Last 3 months

[#1]

Following is the requirement  Default view should show last 3 completed months data. For example, if today’s date is 23-Oct then data of June ,July and Aug should be displayed as part of selection list box. Currently data is available for 9 months

Month-Year

May-13

Jun-13

Jul-13

Aug-13

Sep-13

Oct-13

Nov-13

Dec-13

Please suggest with an example..

[tresesco]

Please take the pain of ceating an example so that people here can help you out faster.

[jonathandienst]

Hi

You could use set analysis like

     {<Date = {">=$(=AddMonths(Today(), -3))""}>}

HTH

Jonathan

[#4]

I need to implement this as part of triggers as it should work with on open sheet

[jagan]

HI,

If you have a date field in you app then use this expression

=Sum({<DateDimensionName={'>=$(=MonthStart(Max(DateDimensionName), -3))<=$(=MonthEnd(Max(DateDimensionName), -1))'}, MonthDimensionName=, YearDimensionName=>} MeasureName)

OR

=Sum({<DateDimensionName={'>=$(=MonthStart(Today(), -3))<=$(=MonthEnd(Today(), -1))'}, MonthDimensionName=, YearDimensionName=>} MeasureName)

Hope this helps you.

Regards,

Jagan.

[kiranmanoharrode]

Dear Sravanthi,

Go to Settings---- Document Settings------- Triggers------ Document Event Triggers-----On Open------Edit Action-----

Add----Selection-----Select in field

(Repeat this 3 times to add 3 triggers)

Enter your TextMonth Field in Field input box without = (sign) for ex.  CommonMonth   values-(APR,MAY,JUN,JUL)

then  put below expression for search string input box with = (Sign)

for 1st trigger

=(Today()=MonthEnd(Today()),Date(Addmonths(Today(),-1),'MMM'),Date(Addmonths(Today(),-2),'MMM'))

for 2nd trigger

=(Today()=MonthEnd(Today()),Date(Addmonths(Today(),-1),'MMM'),Date(Addmonths(Today(),-3),'MMM'))

for 3rd Trigger

=(Today()=MonthEnd(Today()),Date(Addmonths(Today(),-1),'MMM'),Date(Addmonths(Today(),-4),'MMM'))

Save your document and reopen it.

Regards

Kiran Rode

+91 8976977897

[#7]

Hi Kiran,

3 rd trigger is replacing previous two triggers and only one month is selected....Requirement is to select all three months.....

[jagan]

Hi,

Instead of 3 triggers use on one trigger and use this expression

='(' & Date(Addmonths(Today(),-1),'MMM') & '|' & Date(Addmonths(Today(),-2),'MMM') & '|' & Date(Addmonths(Today(),-3),'MMM') & ')'

Regards,

Jagan.

[#9]

It did not work....

[jagan]

Hi,

Please find attached file hope it helps you.  If it not works then attach sample file.

Regards,

Jagan.