I need one tip regarding YOY and also its visulaization.
I want suggestions where i want to get YOY using Quick Table Calculation (Year over Growth) and also want to show KPI's like arrow as shown above.
Calculation used for KPI arrows:
IF (ZN(SUM([Premium])) > LOOKUP(ZN(SUM([Premium])), -1)) then 'Good'
elseif (ZN(SUM([Premium])) < LOOKUP(ZN(SUM([Premium])), -1)) then 'Bad'
Complex scenarios:The issues I have been facing is that I want to remove null(keep blank for year 2016) and also change/keep the column name on which i have done quick table calculation which have not happened in the above screenshot,At the same time, I also want to show KPI arrows and do not want to show yellow arrow as we are starting YOY from 2016.So, i want to keep blank for the reference year 2016.