avisoft20
Board Regular
- Joined
- Sep 10, 2016
- Messages
- 64
Dear Expert,
I have a database given below i want to calculate top 5
first top 5 multiply by 10 in next column i.e PERCENT column.
first top 5 multiply by 7.5 in next column i.e PERCENT column.
first top 5 multiply by 5 in next column i.e PERCENT column.
Calculation range changed when party name chaned
for example i have also attached jpeg for best understand my query.
[TABLE="width: 690"]
<tbody>[TR]
[TD]Party Name[/TD]
[TD]Brand (GRP-1)[/TD]
[TD]Prod.hier.Details[/TD]
[TD]TOTAL[/TD]
[TD]Percent[/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]AARTI[/TD]
[TD]Steam Premium[/TD]
[TD]25[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]BEMISAL[/TD]
[TD]Steam Long Grain[/TD]
[TD]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]BEMISAL[/TD]
[TD]Steam Tibar[/TD]
[TD]42[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]DUBBLE CHABHI[/TD]
[TD]Raw Super[/TD]
[TD]950[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]DUBBLE CHABHI[/TD]
[TD]Raw Tibar[/TD]
[TD]650[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]DUBBLE CHABHI[/TD]
[TD]Brown Wand[/TD]
[TD]45[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]DUBBLE CHABHI[/TD]
[TD]Raw Classic[/TD]
[TD]30[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]INDIA GATE[/TD]
[TD]Raw Kinki[/TD]
[TD]125[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]INDIA GATE[/TD]
[TD]Raw Mini Mogra[/TD]
[TD]70[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]INDIA GATE[/TD]
[TD]Raw Mogra[/TD]
[TD]60[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Steam Wand[/TD]
[TD]25[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Golden Sella Tibar[/TD]
[TD]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Raw Mini Dubar[/TD]
[TD]10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Golden Sella Super Tibar[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Raw Feast Rozzana[/TD]
[TD]96[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Golden Sella Supreme[/TD]
[TD]50[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Raw Dubar[/TD]
[TD]40[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES-TOTAL
[/TD]
[TD][/TD]
[TD][/TD]
[TD]2258[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]AARTI[/TD]
[TD]Steam Premium[/TD]
[TD]125[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]BEMISAL[/TD]
[TD]Steam Long Grain[/TD]
[TD]25[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]BEMISAL[/TD]
[TD]Steam Tibar[/TD]
[TD]96[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]DUBBLE CHABHI[/TD]
[TD]Raw Super[/TD]
[TD]25[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]DUBBLE CHABHI[/TD]
[TD]Brown Wand[/TD]
[TD]75[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]DUBBLE CHABHI[/TD]
[TD]Raw Classic[/TD]
[TD]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]DUBBLE CHABHI[/TD]
[TD]Raw Tibar[/TD]
[TD]60[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]INDIA GATE[/TD]
[TD]Raw Kinki[/TD]
[TD]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]INDIA GATE[/TD]
[TD]Raw Mini Mogra[/TD]
[TD]50[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]INDIA GATE[/TD]
[TD]Raw Mogra[/TD]
[TD]10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Raw Feast Rozzana[/TD]
[TD]42[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Steam Wand[/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Golden Sella Super Tibar[/TD]
[TD]40[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Golden Sella Supreme[/TD]
[TD]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Golden Sella Tibar[/TD]
[TD]30[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Raw Mini Dubar[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Raw Dubar[/TD]
[TD]30[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES-TOTAL[/TD]
[TD][/TD]
[TD][/TD]
[TD]660[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
LINK : https://drive.google.com/open?id=1LjatuP7SWQxpxKDV4Yobek3vQH8Ews6B
I have a database given below i want to calculate top 5
first top 5 multiply by 10 in next column i.e PERCENT column.
first top 5 multiply by 7.5 in next column i.e PERCENT column.
first top 5 multiply by 5 in next column i.e PERCENT column.
Calculation range changed when party name chaned
for example i have also attached jpeg for best understand my query.
[TABLE="width: 690"]
<tbody>[TR]
[TD]Party Name[/TD]
[TD]Brand (GRP-1)[/TD]
[TD]Prod.hier.Details[/TD]
[TD]TOTAL[/TD]
[TD]Percent[/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]AARTI[/TD]
[TD]Steam Premium[/TD]
[TD]25[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]BEMISAL[/TD]
[TD]Steam Long Grain[/TD]
[TD]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]BEMISAL[/TD]
[TD]Steam Tibar[/TD]
[TD]42[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]DUBBLE CHABHI[/TD]
[TD]Raw Super[/TD]
[TD]950[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]DUBBLE CHABHI[/TD]
[TD]Raw Tibar[/TD]
[TD]650[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]DUBBLE CHABHI[/TD]
[TD]Brown Wand[/TD]
[TD]45[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]DUBBLE CHABHI[/TD]
[TD]Raw Classic[/TD]
[TD]30[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]INDIA GATE[/TD]
[TD]Raw Kinki[/TD]
[TD]125[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]INDIA GATE[/TD]
[TD]Raw Mini Mogra[/TD]
[TD]70[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]INDIA GATE[/TD]
[TD]Raw Mogra[/TD]
[TD]60[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Steam Wand[/TD]
[TD]25[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Golden Sella Tibar[/TD]
[TD]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Raw Mini Dubar[/TD]
[TD]10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Golden Sella Super Tibar[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Raw Feast Rozzana[/TD]
[TD]96[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Golden Sella Supreme[/TD]
[TD]50[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Raw Dubar[/TD]
[TD]40[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AASHIRWAD AGENCIES-TOTAL
[/TD]
[TD][/TD]
[TD][/TD]
[TD]2258[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]AARTI[/TD]
[TD]Steam Premium[/TD]
[TD]125[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]BEMISAL[/TD]
[TD]Steam Long Grain[/TD]
[TD]25[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]BEMISAL[/TD]
[TD]Steam Tibar[/TD]
[TD]96[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]DUBBLE CHABHI[/TD]
[TD]Raw Super[/TD]
[TD]25[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]DUBBLE CHABHI[/TD]
[TD]Brown Wand[/TD]
[TD]75[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]DUBBLE CHABHI[/TD]
[TD]Raw Classic[/TD]
[TD]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]DUBBLE CHABHI[/TD]
[TD]Raw Tibar[/TD]
[TD]60[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]INDIA GATE[/TD]
[TD]Raw Kinki[/TD]
[TD]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]INDIA GATE[/TD]
[TD]Raw Mini Mogra[/TD]
[TD]50[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]INDIA GATE[/TD]
[TD]Raw Mogra[/TD]
[TD]10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Raw Feast Rozzana[/TD]
[TD]42[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Steam Wand[/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Golden Sella Super Tibar[/TD]
[TD]40[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Golden Sella Supreme[/TD]
[TD]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Golden Sella Tibar[/TD]
[TD]30[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Raw Mini Dubar[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES[/TD]
[TD]KOHINOOR[/TD]
[TD]Raw Dubar[/TD]
[TD]30[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PRAKASH AGENCIES-TOTAL[/TD]
[TD][/TD]
[TD][/TD]
[TD]660[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
LINK : https://drive.google.com/open?id=1LjatuP7SWQxpxKDV4Yobek3vQH8Ews6B