5 Replies Latest reply: Jun 30, 2017 1:47 AM by Lech Miszkiewicz RSS

    Pie Chart Colour for Maximum Value

    Chay Him

      Hi

       

      I have a pie chart which shows Sum(Revenue) by Sales Channel.

       

      What I would like to show is for the slice with the largest Sum(Revenue) to be coloured in Green, whilst all other slices to be in grey.

       

      May I know what kind of expression should I be using? I've tried colour mix and IF but they're not working.

       

      Thanks in advance!