4 Replies Latest reply: Feb 21, 2012 8:09 AM by Chandrashekar Jakkula RSS

    Problem with Rank

      Dear All,

       

      i

      want to display region wise top five customers sales and rest of other customer sales with label  "Others", when i writen rank with aggr in pivot table its giving wrong no. of customers and sales value.

      please give a solution.

      for your reference i attached the file, in that file contains 2 table green table is containing the requirement and blue table contans data for validation

       

      Thanks in advance

       

      chandu jak