I have a simple set of KPIs and I am use a current month and comparing against previous month. I am using column data model with dates as rows and KPIs as columns. I can't seem to figure out how to automatically add green up arrows for positive variances and red down arrows for negative variances.
How do I go about adding a simple up/down green/red KPI indicator to each variance calculation that is done automatically in the list of KPIs?
I read the instructions about using Method 2 for a calculated column but in this case would i have to create a new calculated column for every single KPI even though they are all being calculated automatically? I am not understanding. I simply want to add the indicator to the already automatically populated column of variances between actual and comparison columns. Any help would be appreciated!
