6 Replies Latest reply on Jun 22, 2017 2:20 AM by Mahfooj Khan

    How to display top 3 item sales and overall item sales

    Kes Raj

      Hi,

       

      I want to display top 3 sales and overall sales in same view i.e in one worksheet. Below is the sample data.

       

       

      Sl.NoTV MODELSSALES
      1Samsung20000
      2Videocon400000
      3LG8000
      4Sony100000
      5Ace200000
      6BPL65000
      7Onida45000
      8Crown80000
      9Panasonic90000
      10Philips

      35000

       

       

      Output Result mentioned below:

       

       

      VideoconTop 3 sales
      Ace
      Sony
      SamsungOverall Sales
      Videocon
      LG
      Sony
      Ace
      BPL
      Onida
      Crown
      Panasonic
      Philips

      How to achieve above requirement in one view, can anyone help me on this. Mahfooj Khan Bayapa Reddy