Dear Friends
i revised the output sheet please look it at again if that possible through pivot table or sumif function
in the output sheet column are Gross Arrear Current Amount Net Amount
Gross Arrear is ARGROSS
Current amount is (NETAMT-ARGROSS)
Net Amount is NETAMT
Now in top ten defualter mean sum of top 10 argross of tarrif category. Like this other category top 10 and top 100 if possible and this data fetch from oracle database.
Thanks
Manoj
Bookmarks