Thanks for your quick reply. In other group top 3 names also need to displayed..i.e in other group all items.
Below is the output i am looking for.....
= (Videocon,Ace,Sony)->Top 3 Sales,(Samsung,Videocon,LG,Sony,Ace,BPL,Onida,Crown,Panasonic,Philips)->Overall Sales
= Top 3 sales + Overall Sales = Videocon, Ace, Sony, Samsung, Videocon, LG, Sony, Ace, BPL, Onida, Crown, Panasonic, Philips
As per my understanding having both the information in a single view is not possible. Either you should go with what Shin sir suggested or find my approach. You've to use two different sheets to displays both Top3 and Overall. Like this
Let us know if this helps.