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.
