Dynamic Fiscal Year

[darrellbutler]

Hi I have a graph which has month and year on the x axes, the y expression is a rolling 12 mths sales . For example  Dec 11 will show sales for Dec 10 - Dec 11.

I then want to divide into this figure the full sales for the previous fin year (Apr 10 - Mar 11) how can i make this dynamic. For example Dec 10 rolling sales covering the period Dec 09 - Dec 10 should be divided by Apr 09 - Mar 10 - how do I make the fiscal year dynamic based on the x axes dimension ?

Many thanks for your help.

Darrell.