9 Replies Latest reply: Oct 17, 2013 2:27 PM by Anju Gopinath RSS

    top 10 values for the highest value of year

      Hi,

       

      I have a date field,

       

      I want to pick out the highest value of year from the dates and I want to display the top 10 dates in that year having the highest count for a particular field..

       

      I gave this in the dimension in a straight table,

       

      =IF(DATE(SUBFIELD(RPX_ACTIVATION_DATE,' ',1),'YYYY')='2013',RPX_ACTIVATION_DATE,NULL())

       

      2nd dimension ->RPX_ACTIVATION_DATE

      and in the expression,

       

      I gave count(MRP_ID_SDP)..

       

      but, the straight table is not being populated ... the dimension field is null...

       

      How do I get the desired result?

       

      Thanks,

      Anju