Moving Window chart

[amars]

Hi all,

I have a new requirement for a chart which should be as shown in below image

Can somebody suggest on the Best possible ways to design such a chart?

Thanks in Advance.

Amar

[#2]

Hi,

You can create a calculated dimension in a chart using this code

=aggr(max(Year),Year)&' - '&aggr(max(Year)+3,Year)

Regards,

Janzen