calculate sales value based on top 3 target

[rajasekar_o]

I  have data of target and sales 
1.I want to calculate ASM wise  sales based on  top3flg=y and top3 target
2.BM wise  sales Based on top3flg=y and top3 target

dealer code	ASO code	ASM code	BM code	target	sales	top 3flg
DEALE-01	ASO-01	ASM-01	BM-01	1000	985	Y
DEALE-02	ASO-01	ASM-01	BM-01	3245	868
DEALE-03	ASO-01	ASM-01	BM-01	2454	8686	Y
DEALE-04	ASO-01	ASM-01	BM-01	5375	8668
DEALE-05	ASO-01	ASM-01	BM-01	8453	6546	Y
DEALE-06	ASO-02	ASM-01	BM-01	5353	6464
DEALE-07	ASO-02	ASM-01	BM-01	5436	5364	Y
DEALE-08	ASO-02	ASM-01	BM-01	4324	5363	Y
DEALE-09	ASO-02	ASM-01	BM-01	9574	6464
DEALE-10	ASO-02	ASM-01	BM-01	9575	8437	Y
DEALE-11	ASO-03	ASM-01	BM-01	8564	4443	Y
DEALE-12	ASO-03	ASM-01	BM-01	7593	5356	Y
DEALE-13	ASO-03	ASM-01	BM-01	6345	7567
DEALE-14	ASO-03	ASM-01	BM-01	4345	4535	Y
DEALE-15	ASO-03	ASM-01	BM-01	3425	7654	Y
DEALE-16	ASO-04	ASM-01	BM-01	3645	2345
DEALE-17	ASO-04	ASM-01	BM-01	8675	3437	Y
DEALE-18	ASO-04	ASM-01	BM-01	5342	4645
DEALE-19	ASO-04	ASM-01	BM-01	3545	3678	Y
DEALE-20	ASO-04	ASM-01	BM-01	4243	4267	Y
DEALE-21	ASO-05	ASM-01	BM-01	7438	8453
DEALE-22	ASO-05	ASM-01	BM-01	9857	5353	y
DEALE-23	ASO-05	ASM-02	BM-01	9575	5436
DEALE-24	ASO-05	ASM-02	BM-01	9585	4324	y
DEALE-25	ASO-05	ASM-02	BM-01	9474	9574
DEALE-26	ASO-06	ASM-02	BM-01	9876	9575
DEALE-27	ASO-06	ASM-02	BM-01	7976	8564	y
DEALE-28	ASO-06	ASM-02	BM-01	8698	7593
DEALE-29	ASO-06	ASM-02	BM-01	7969	6345	y
DEALE-30	ASO-06	ASM-02	BM-01	9797	4345
DEALE-31	ASO-07	ASM-02	BM-01	7547	8453
DEALE-32	ASO-07	ASM-02	BM-01	9759	5353	y
DEALE-33	ASO-07	ASM-02	BM-01	8686	5436
DEALE-34	ASO-07	ASM-02	BM-01	5000	4324	y
DEALE-35	ASO-07	ASM-02	BM-01	7595	9574
DEALE-36	ASO-08	ASM-02	BM-01	5959	9575	y
DEALE-37	ASO-08	ASM-02	BM-01	9853	8564	y
DEALE-38	ASO-08	ASM-02	BM-01	5398	7593	y
DEALE-39	ASO-08	ASM-02	BM-01	8559	6345
DEALE-40	ASO-08	ASM-02	BM-01	9853	4345	y

[_AAndrade]

Hi @rajasekar_o,

Could you provide the output that you're looking for, using the data that you've shared?

[rajasekar_o]

i want  sales amount of top 3 target 

the expected out put is bm top 3= 26201

[_AAndrade]

@rajasekar_o,

With the data you provided, I can't get those numbers.

Another doubt is that you've asked these questions:
1.I want to calculate ASM wise  sales based on  top3flg=y and top3 target
2.BM wise  sales Based on top3flg=y and top3 target

but you've only presented a simple table.
Could you please indicate the final result you want for each question?

[rajasekar_o]

@_AAndrade 
TOP 2