Remove tail in Rolling R1/R12 chart

[tseebach]

Hi,

I got a rolling months average, and I need some way to cut of the tails of the charts, see the image, the part outside the bar charts areas.

The formula for the green line is this:

(rangeavg(above(sum({$<KEY_ACCNO = {'1600'},Date = {">=$(=(MonthStart(AddMonths(Max(ALL [Date]),-40)))) "},Calender.Year= ,Calender.MonthName= >} $(=ValueFieldAcc)),0,13))*360)
/
rangesum(above(sum({$<KEY_ACCNO = {'80100'},Date = {">=$(=(MonthStart(AddMonths(Max(ALL [Date]),-40)))) "},Calender.Year= ,Calender.MonthName= >} -$(=ValueField)),0,12))

I've tried putting a If around to remove the dates which are not within 36 months. Any ideas?

[#2]

Hi Torben,

Could you attach a file like example. It'll help us for finding a solution quickly.

Best regards.

[tseebach]

Yep,

I've reproduced the issue in this example:

http://dl.dropbox.com/u/1773255/testRollingR12.qvw

[tseebach]

Yep,

I've reproduced the issue in this example:

http://dl.dropbox.com/u/1773255/testRollingR12.qvw