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

    top 10 values for the highest value of year



      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,




      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?