Sum Data and list Top Three

[kundanlal]

Hi..

There is a Raw data (running in 500 rows with multiple Sub-Agent No for earch Main Agent Name) which is required to sum (My Sale Rs-total and Others Sale Rs-total) on the basis of Sub-Agent No+Main Agent Name, rank it on the basis of Others Sale Rs-Total and generate report for top 3 as under :

Can any one help in this..

Main Agent Name	Sub-Agent No	My Sale Rs-Total	Others Sale Rs-Total	Rank
Amar	PNQ0020	0.2​	2167.4​	1​
Amar	PNQ0005	0.2​	1139.5​	2​
Amar	PNQ0164	0​	14​	3​
Jagdish	PNQ0005	0.1​	185.5​	1​
Jagdish	PNQ0020	0​	41​	2​
Jagdish	PNQ0164	0​	2​	3​
Kapoor	PNQ0020	0.1​	1206​	1​
Kapoor	PNQ0005	0.4​	317.9​	2​
Kapoor	PNQ0164	0​	4.4​	3​

Thanks and Regards,

Kundanlal

 

[GraH - Guido]

Seems doable with a pivot table.

Make the pivot


Sort on SUM of Others Sale


Filter on "TOP 10"


Define TOP 3 as followed.

 

[kundanlal]

Appreicated.. Thanks Sir.. I will certainly use this...

Actually, these report so generated is part of my other report.. Forumula based solution is very much welcome..

Regards,

Kundanlal

 

[John Jairo V]

Hi, to all!

Check this file, with an option (check name manager, with a formulated name "codes"). Blessings!

 

[kundanlal]

Thank you Sir..