Calculated Dimension

[vardhancse]

Hi,

Have a requirement is that,

	sum(Cost)	sum(Cost)	YOY	YOY
Period	2013	2014	2013	2014
Team	2013	2014	2013	2014
TeamA	10	20	▼	▲
TeamB	15	25	▼	▲

As of now which ever value is higher its showing ▲ or ▼.

but now it should calculate the difference between period 2014 and 2013 and only if difference > 2 then only the ▲ should display in YOY.

PFA QVW for reference

[vardhancse]

gwassenaar‌ jagan‌ Can please help me in getting the same

[tresesco]

Try expression :

=if(fabs(Sum(Cost)-After(Sum(Cost)))>2,'▲','▼')