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

    Pie Chart Colour for Maximum Value

    Chay Him



      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!