IF SUM(Sales) - LOOKUP(SUM(sales), -1) >0 then "INCREASE" else "DECREASE" end
You could have an ELSEIF in there to check for no change too.
Here is the solution tested, kindly follow the steps
1. create calculated field "Increase/Decrease"
IF SUM([Sales]) = LOOKUP(SUM([Sales]),-1)
THEN "No Variance"
ELSEIF SUM([Sales]) > LOOKUP(SUM([Sales]),-1)
2. Take [Year] to Row and make it as Discrete
3. Place "Increase/Decrease", calculated field to Text and also to Color
4. Format the table, if you want
Explanation : minus 1 LOOKUP will get you previous row value. Please be careful, previous value is based on sort order whether from 2010 to 2015 or 2015 to 2010. Hence table calculation is to be edited to reflect as below
here is the output.
MUHAMMAD MAHMOD.twbx 46.3 KB
Thank you GANAPATHY PALANIMUTHU . you are my hero today. this is correct answer i'm looking for.
Welcome, it's my pleasure
please take note of the edit table calculation explained in the first reply, otherwise change of sort order of year will impact the solution