The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 |
Hi @rajasekar_o,
Could you provide the output that you're looking for, using the data that you've shared?
Proud to be a Super User!
i want sales amount of top 3 target
the expected out put is bm top 3= 26201
@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?
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
92 | |
90 | |
72 | |
69 |
User | Count |
---|---|
231 | |
127 | |
117 | |
82 | |
82 |