I have a chart which shows the client name and revenue generated from client. If I want to highlight all those customers who contributed to 80% of profit, how can I do that. So basically I have two questions here
1) What is the expression to calculate all those customers who contributed to 80% of total profit
2) How to conditionally format the profit of customer so that it it contributes to 80% of total profit, make it red