Forum Discussion
TOP 5 SALES
Hi team ,
i want to calculate top 5 sales
ASO top5 is calculation
calculate sales based on flag=y and top5 target
ASM top5 is calculation
calculate sales based top5 sales from ASO TOP5 BM top5 is calculation
calculate sales based top5 sales from ASM TOP5
Employee
| dealer | aso | asm | bm | flg |
| Dealer1 | aso1 | asm1 | bm1 | y |
| Dealer2 | aso1 | asm1 | bm1 | y |
| Dealer3 | aso1 | asm1 | bm1 | N |
| Dealer4 | aso1 | asm1 | bm1 | y |
| Dealer5 | aso1 | asm1 | bm1 | N |
| Dealer6 | aso1 | asm1 | bm1 | y |
| Dealer7 | aso1 | asm1 | bm1 | N |
| Dealer8 | aso1 | asm1 | bm1 | y |
| Dealer9 | aso1 | asm1 | bm1 | N |
| Dealer10 | aso1 | asm1 | bm1 | y |
| Dealer11 | aso1 | asm1 | bm1 | N |
| Dealer12 | aso1 | asm1 | bm1 | y |
| Dealer13 | aso1 | asm1 | bm1 | y |
| Dealer14 | aso1 | asm1 | bm1 | y |
| Dealer15 | aso1 | asm1 | bm1 | y |
| Dealer16 | aso2 | asm1 | bm1 | y |
| Dealer17 | aso2 | asm1 | bm1 | N |
| Dealer18 | aso2 | asm1 | bm1 | y |
| Dealer19 | aso2 | asm1 | bm1 | y |
| Dealer20 | aso2 | asm1 | bm1 | N |
| Dealer21 | aso2 | asm1 | bm1 | y |
| Dealer22 | aso2 | asm1 | bm1 | N |
| Dealer23 | aso2 | asm1 | bm1 | N |
| Dealer24 | aso2 | asm1 | bm1 | N |
| Dealer25 | aso2 | asm1 | bm1 | y |
| Dealer26 | aso2 | asm1 | bm1 | y |
| Dealer27 | aso2 | asm1 | bm1 | y |
| Dealer28 | aso2 | asm1 | bm1 | y |
| Dealer29 | aso2 | asm1 | bm1 | y |
| Dealer30 | aso2 | asm2 | bm1 | y |
TARGET
| SALES dealer | TARGET |
| Dealer1 | 245223 |
| Dealer2 | 24524 |
| Dealer3 | 546456 |
| Dealer4 | 454563 |
| Dealer5 | 35635 |
| Dealer6 | 35635 |
| Dealer7 | 3635 |
| Dealer8 | 36353 |
| Dealer9 | 875875 |
| Dealer10 | 7465 |
| Dealer11 | 3537 |
| Dealer12 | 8676 |
| Dealer13 | 46445 |
| Dealer14 | 4536 |
| Dealer15 | 65367 |
| Dealer16 | 7656 |
| Dealer17 | 3456 |
| Dealer18 | 7642 |
| Dealer19 | 4764 |
| Dealer20 | 8753 |
| Dealer21 | 346576 |
| Dealer22 | 3455 |
| Dealer23 | 35646 |
| Dealer24 | 32445 |
| Dealer25 | 34545 |
| Dealer26 | 24354 |
| Dealer27 | 3463 |
| Dealer28 | 5434 |
| Dealer29 | 35635 |
SALES
| dealer | SALES |
| Dealer1 | 245359 |
| Dealer2 | 24660 |
| Dealer3 | 546592 |
| Dealer4 | 454699 |
| Dealer5 | 35771 |
| Dealer6 | 35771 |
| Dealer7 | 3771 |
| Dealer8 | 36489 |
| Dealer9 | 876011 |
| Dealer10 | 7487.5 |
| Dealer11 | 3559.5 |
| Dealer12 | 8698.5 |
| Dealer13 | 46467.5 |
| Dealer14 | 4558.5 |
| Dealer15 | 65389.5 |
| Dealer16 | 7678.5 |
| Dealer17 | 3478.5 |
| Dealer18 | 7664.5 |
| Dealer19 | 4946.5 |
| Dealer20 | 8935.5 |
| Dealer21 | 346758.5 |
| Dealer22 | 3637.5 |
| Dealer23 | 35828.5 |
| Dealer24 | 32627.5 |
| Dealer25 | 244560.5 |
| Dealer26 | 23861.5 |
| Dealer27 | 545793.5 |
| Dealer28 | 453900.5 |
| Dealer29 | 34972.5 |
| Dealer30 | 34972.5 |
2 Replies
1. ASO Top 5 Sales
ASO Top 5 Sales =
VAR TopASO =
TOPN(
5,
SUMMARIZE(
DealerData,
DealerData[ASO],
"ASO Sales", SUM(SalesData[Sales])
),
[ASO Sales],
DESC
)
RETURN
CALCULATE(
SUM(SalesData[Sales]),
KEEPFILTERS(TopASO),
DealerData[Flag] = "Y"
)2. ASM Top 5 Sales
ASM Top 5 Sales =
VAR TopASM =
TOPN(
5,
SUMMARIZE(
DealerData,
DealerData[ASM],
"ASM Sales", [ASO Top 5 Sales]
),
[ASM Sales],
DESC
)
RETURN
CALCULATE(
[ASO Top 5 Sales],
KEEPFILTERS(TopASM)
)3. BM Top 5 Sales
BM Top 5 Sales =
VAR TopBM =
TOPN(
5,
SUMMARIZE(
DealerData,
DealerData[BM],
"BM Sales", [ASM Top 5 Sales]
),
[BM Sales],
DESC
)
RETURN
CALCULATE(
[ASM Top 5 Sales],
KEEPFILTERS(TopBM)
)
If this helped, a Kudos 👍 or Solution mark would be great!🎉
Cheers,
Kedar Pande
Connect on LinkedInASO Top 5 Sales =
VAR TopASO =
TOPN(
5,
SUMMARIZE(
DealerData,
DealerData[ASO],
"ASO Sales", SUM(SalesData[Sales])
),
[ASO Sales],
DESC
)
RETURN
CALCULATE(
SUM(SalesData[Sales]),
KEEPFILTERS(TopASO),
DealerData[Flag] = "Y"
)I this measure top 5 sales only calculating.
but i need to calculate the sales of flag=y and top5 target
