8 Replies Latest reply: Jul 22, 2010 5:13 AM by umangu2000 RSS

    Ranking in a Textbox

      Hello

       

      i curretnly have a chart the Dimension I have used is Opendatemonth, the expression is Count(distinct incidentid). this gives me a count of incidents in each month.

       

      I wish to write a comment below this table stating :

      the highest volume of incidents this year were in '....'

      Where '...' is the month form the field opendatemonth with the higheest count of incidentids.

       

      Can anyone help please?

       

      Jon