Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How could I create an expression for the variance that would solve this? I need to show it in the bar chart with Year-Quarter as Dimension and it has data up to 2010 totally i need to show 24 bars in the variance chart ,This is the equation we currently use in excel: for variance calculation (Q3 2015-Q3 2014)/Q3 2014. can any one help me on this?
Hi John,
Try this expression
=(Sum(Sales)/Alt(Above(Sum(Sales), 4), 0)) - 1
Regards,
jagan.
Hi John,
Could you please elaborate your problem? I'm not sure that I understood your needs.
Thanks,
Miguel
Hi,
Didn't got Your query right. Can You please explain clearly what you want to obtain.
Thanks,
Bunny
Hi Miguel,
If you see image there in the dimension, I have taken the Fiscal quarter ,which displays all the quarters from starting year to latest year, now I want a bar chart with variance calculation in it, the calculation formula is
variance= (current quarter sales/previous year same quarter value) -1.
Hope you got it!.
Regards
John
Hi Bunny Thanks your Prompt response, Please find the explanation about the requirement on the above.
Hi John,
Try this expression
=(Sum(Sales)/Alt(Above(Sum(Sales), 4), 0)) - 1
Regards,
jagan.
Please check the attached file:
If you found usefull my binary qvw, please mark it as Usefull Have good job.
Sorry Braga Miguel , I didn't find the option to give useful , I have already given to Jagan