
1. Re: Calculation comparison with previous year
Joe Oppelt Dec 8, 2018 8:50 PM (in response to MUHAMMAD MAHMOD)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.

2. Re: Calculation comparison with previous year
Ganapathy Palanimuthu Dec 8, 2018 9:56 PM (in response to MUHAMMAD MAHMOD)Hi Muhammad
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)
THEN "Increase"
ELSE "Decrease"
END
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


3. Re: Calculation comparison with previous year
Ganapathy Palanimuthu Dec 8, 2018 10:53 PM (in response to Ganapathy Palanimuthu) 
4. Re: Calculation comparison with previous year
MUHAMMAD MAHMOD Dec 9, 2018 12:08 AM (in response to Ganapathy Palanimuthu)Thank you GANAPATHY PALANIMUTHU . you are my hero today. this is correct answer i'm looking for.
Best,
RizalMahmod

5. Re: Calculation comparison with previous year
Ganapathy Palanimuthu Dec 9, 2018 12:27 AM (in response to MUHAMMAD MAHMOD)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
Best Regards
Ganapathy Palanimuthu