2 Replies Latest reply: Feb 17, 2012 1:31 AM by Chandrashekar Jakkula RSS

    Top 3 Customers & Rest of all Customers should display as Label With Others in Pivot Table

      Hi All,

       

      i am having table data as follows

       

      CustomerAmt
      a8
      a10
      b20
      c7
      d10
      e15
      f12
      f20

       

      I Want to Display Data in Pivot Table as Top 3 Customer Names and rest of the customers total as Label Others as shown below

       

      CustomerAmt
      f32
      b20
      a18
      Others32
      Total102

       

      Please Help me in resolving the above.

       

       

      Thanks in Advance.

       

      Chandu