12 Replies Latest reply: Jul 15, 2016 1:16 AM by Bharat Kishore RSS

    Need to show top 10

    Bharat Kishore

      Hi All,

       

      I need to show top 10 records based on the Email Sent Date.

       

      I have given the calculated dimension like this..

      =if(Aggr(If(Rank(sum([Email Sent Date])) <= 6,sum([Email Sent Date])), Email_Market,Email_Brand,[Email Subject Line])

      ,[Email Subject Line])

       

      But it is not fetching the latest(or) last 10 records.

       

      Kindly suggest.

       

      Thanks,

      Bharat