I have a pivot table that has two columns, one shows the average compliance score then the next column shows the trend with arrow indicators.
For the compliance average I use this expression:
For the arrow indicators I use this expression:
If(Avg([UMHC SYSTEM]) >0.945,Black(),
What I want to do is have the trend indicator arrow go up if the percentage from month to month is going up, and an arrow going down if the percentages have gone down from month to month. And if there is no change just a dash.
Can anyone help me with this?