8 Replies Latest reply: Nov 9, 2012 10:31 AM by mayilvahanan ramasamy RSS

    Ranking cells by colour in a chart

      Hello,

       

      I have a created a straight table with a dimension of 'Site' and a number of different expressions (e.g. Sales, Overheads etc etc as you can see below). What I want to do is assign different colours against each cell based on it's rank, i.e. in the below example for Sales I want to give Glasgow - blue (as it has the most sales), London - green (2nd most sales), Dublin - orange (3rd most sales) and Belfast - red (4th most sales). This would be the same approach for the other expressions and I've also attached the current expression I have (the 'Week' field is based on a variable to look back at the last 6 weeks). Any help as to how I can implement this would be most appreciated.

       

      BelfastLondonDublinGlasgow
      Sales23433267
      Overheads123245563321
      Attendance3.34.11.14.5
      Output5467900213

       

       

      Sum

      ({<Site={"Belfast"}, Week={$(=vCurrentWeek),$(=(vCurrentWeek-2)),$(=(vCurrentWeek-3)),$(=(vCurrentWeek-4)),$(=(vCurrentWeek-5)),$(=(vCurrentWeek-1))}>} Sales)

       

      Thanks,

       

      Ralph