14 Replies Latest reply on May 5, 2016 5:30 AM by pooja.gandhi

    How to find Top 4 customers in each category based on sales??

    Sangaraju Haripriya

      I'm  trying to find top 4 customers based on sales in each category. i tried by using parameters,calculations and context filters too but i'm not getting the exact result which i want .It will be helpful if any one solve this.exactly i want in this way

       

       

      Header 1Header 2Header 3
      Furniture

      sean miller

      Jhon

      michel

      thomas

      $23,000

      $18,000

      $13,000

      $7,000

      Office supplies

      Jhon

      michel

      thomas

      sean miller

      $25,000

      $12,000

      $5,000

      $4,000

      Technology

      michel

      thomas

      Jhon

      sean miller

      $8,000

      $7,000

      $3,000

      $1,000

      Waiting for replay................................