This content has been marked as final. Show 2 replies
I have a project where a client would like to see % Achieved (calculated field) on a pie chart. I do this by creating another calculation [1-Achieved%] and follow the steps to get the pie chart.
I need the % Achieved slice to show as Green if it's over 80% and Red otherwise. I can't post the original workbook so I've tried to replicate the scenario with the Superstore data (as attached).
I'm not able to get all 3 colours into one calculation.