21 Replies Latest reply: Jun 30, 2016 2:23 AM by Deepak Sharma RSS

    Displaying Top n Values in Pivot table

    Deepak Sharma

      Hi

       

      I am trying to display top n values (5,10,15...etc) in Pivot table. As Dimension Limits is not available in pivot table someone assist me to achive this functionality.

       

      RegionCountryStateRisk CategoryRisk Score
      ASPINDUPAccounting5
      ASPSrilunkaJFCivil80
      EURUKLNEU20
      EURUKLNCredit20
      EURGER-RR39
      NAUSILWR95
      NAUSFLRR5
      NACanadaKIF36

       

       

      In expression tab I am calculating Avg(Risk Score)

       

      Please assist