Three months earlier

[pgalvezt]

Hello,

Currently I'm working on debt models. I'm trying to extract the 3 months earlier with another table. For example If I do clic on Jan2011 I need to get Nov2011, Dic2011,Jan2011. If I do clic On Feb2011 I need to get Dic2011, Jan2011,Feb2011 and so on. How ca I do achieve this?

I left an attached sample for better comprenhension.

Thank You!

[Gysbert_Wassenaar · Accepted solution]

Simply select a date in ReportMes. You will see that three months in Fecha_Protesto are still 'active' (possible). The others are unselected (excluded) and not counted in the calculations. If I understood you correctly, this is what you were trying to achieve. If so, congratulations!

[pgalvezt]

Just one more question. How can I left the date using Monthname function inside the Inline Table?

Thank you for your help!

[Gysbert_Wassenaar]

I don't understand your question. But perhaps the answer you're looking for is a preceding load.

Report_Table:

Load *, monthname(ReportMes) as ReportMonth

Load * Inline[

ReportMes, Fecha_Protesto

31/01/2011, 30/11/2010

31/01/2011, 31/12/2010

31/01/2011, 31/01/2011

28/02/2011, 31/12/2010

...

];

What happens above is that the results of the inline load are used in the load statement just above it. In this case the monthname function is applied to the ReportMes field to create a new field named ReportMonth. I hope this helps.

[pgalvezt]

The clean field format = DD/MM/YYYY

With the MonthName Function gives (Jan 2010, Feb 2010 So on)

In my script I used MonthName. But in Inline Table Doesn't work gives Error.