show a time period in chart based on max date

[#1]

Hi All,

I would like a chart to show the six months ending in the max associated date.  I have tried the following:

            =SUM({$<CLOSEMONTH_SORT = {">= $(vRolling6MonthMin)"}>}RO_FLAG)

where vRolling6MonthMin is defined as the max date minus six months.  This works correctly if a range of more than six months is selected.  For example, if I select January thru November, it shows me June thru November.  But if I select only November, it shows me only November.  How can I make it ignore the date selection, but still determine the range based on the highest selected date?

Thanks for your help.

[Gysbert_Wassenaar · Accepted solution]

Add modifiers for the fields you want to be ignored:

=SUM({$<MyMonthField=, CLOSEMONTH_SORT = {">= $(vRolling6MonthMin)"}>}RO_FLAG

[#3]

Thanks, Gysbert.  That works, but because I am ignoring those fields, I have to define both a beginning and end date--so the expression becomes

     =SUM({<CLOSEMONTH_SORT = {">= $(vRolling6MonthMin)"} * {"<= $(vCurrentMonth)"}, YEAR=, QUARTER=, MONTH= >}RO_FLAG)