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.