Chart showing current month and previous 12 (13 mths)

[rcorcoran]

Hi

See attached - I need this chart to show 13 months so if the year 2014 is selected it should show current month plus 12 mths previous.  Also if 2013 is picked it should show all of 2013 plus dec of 2012.

So basically it should show max month of year picked and 13 mths in total

Hope that makes sense

any help appreciated

[saumyashah90]

It would be helpful if you have single date field and not year month as separate fields

[jpenuliar]

Agreed.

a Refferal Date field will be useful because you can use AddMonths(Today(),-13)) function to go back 13 months from your selected date.

If you have date fields, you can move to Master/Common Calendars to provide for the Month and Year for periodic selections.

[saumyashah90]

As Jonathan said:

AddMonths(Today(),-13))  will help you.

how you can approach is.

you can use calendar objects to it: Start_Date_Calendar and End_Date_Calendar

Define Start_Date_Calendar =AddMonths(GetFieldSelections(DateField),-13))

End_Date_Calendar = GetFieldSelections(DateField)

and this work as you require