Percentage Increase spend over the years
I am having a little trouble in finding % increase for every year from 2013 to 2016. For clarity see the table below:\
These are random values for sales.
Intially I was using the following formula:
((If(Sum([Sales]) is null, 0 ,Sum([Sales]))) - Sum([Sales]) OVER (Previous([Axis.X])))
(If(Sum([Sales]) is null,0,Sum([Total_Amount_of_Payment_USDollars])))
However the issue is, as you can see in the table, I donot have sales value for Banana for year 2013 and 2015, so in an ideal condition it should show me a 100% increase in 2014 and 2016. For this purpose I added a simple condition to my formula, however its not working as i want. Can someone help me in this regard?