KPI - Tableau

Question

HI, I want to show arrows for every increase or decrease of sales and profit from the previous row. Can someone help.

I want to show green up and red down arrows for the increase and decrease.

Answer 1

Create a calculated field as below,

IF ZN(SUM([Sales])) - LOOKUP(ZN(SUM([Sales])), -1) >=0 THEN "Increase" ELSE "Decrease" END.

Replace sales by profit for profit KPI similarly.

Drop the above field in shapes shelf and select the respective arrow marks from shape shelf.