How to create an expression for variance

[#1]

My company relies on variance to see the year over year and quarter over quarter picture. How could I create an expression that would solve this? This is the equation we currently use in excel: (Q3 2012-Q3 2011)/Q3 2011. For exemple, (cell B14-cellcell B10)/cell B10. Has anyone had this issue before and found a solution?

[rajni_batra]

You can use the following if ur quarters are already defined...

(Sum({<Year={"=$(max(Year))"},Quarter={"=$(max(Quarter))"}>}Sales) - Sum({<Year={"=$(max(Year))-1"},Quarter={"=$(max(Quarter))"}>}Sales))/ Sum({<Year={"=$(max(Year))-1"},Quarter={"=$(max(Quarter))"}>}Sales))

Hope to Help!!!

[#3]

Did you get the solution for this? if yes how did you solve it? I am also having the same problem please help me on this.

Regards

John