1 Reply Latest reply: May 3, 2012 9:39 AM by Dennis Hoogenboom RSS

    Top N rows, Total of Top N and  total of All others

    Sonika Jain

      Dear all,

      I am stuck in a scenario where I have to display top 50 rows for a measure in a pivot table, then display the total of 50 rows, and then a row for total of remaining rows (others)

       

      An elaboration to this - I need somthing like below :

      HospitalsAmount
      abc1234
      def2345
      efg56767
      they5677
      Total
      Others Total


       

      I can find the option for restricting values to top 50, and the options for all others and Total, but that total is gives the sum of all the rows, and not the top N rows. Please help me on this.

       

      Thanks