1 Reply Latest reply on Dec 4, 2014 7:40 AM by Praveen Bandi

    Need to create a top nth value using calculated field

    Praveen Bandi

      Hi everyone,

       

      we need to create a top nth value using calculated field from below table:

       

      Offer NameSales
      OfferName110
      OfferName240
      OfferName330
      OfferName435
      OfferName525

       

      we are looking for the report something like below:

       

      Top 4 OfferName (No need to have a Offername here its just an individual Measure)25
      Top 3 OfferName (No need to have a Offername here its just an individual Measure)30

       

      Please help me to acheive this...