96%

81% 100%

Share of Sellers Rank

100% 82%

II III

I IV

76% 61%
 76% 61%

Plan Sales by Quarters

https://exceltable.com/en/templates/dashboard-for-analyzing-
 https://ex

11 22 33 2021

Top 33 Sellers Rank

Top
 23%
23% 100%
100% 33%
33% 80% 67%
80%
AA BB CC D
D EE

Product Rank

d-for-analyzing-sales-ranking
https://exceltable.com/en/templates/
 Date Product A Product B Product C Product D Product E Seller 1 Seller 2 Seller 3
3/31/2020 300 400 500 1000 750 1000 1000 1000
6/30/2020 300 400 500 1000 750 1000 1000 1000
9/30/2020 300 400 500 1000 750 1000 1000 1000
12/31/2020 300 400 500 1000 750 1000 1000 1000
1/31/2021 0 14728 10456 14377 22961 6108 5291 9786
2/28/2021 175 19611 2256 15998 10987 5330 1264 6848
3/31/2021 9937 15439 6018 6425 3432 2430 6885 2583
4/30/2021 2487 19314 5264 9686 11533 2673 2506 8780
5/31/2021 0 7881 6800 18243 16731 9944 9112 3499
6/30/2021 4399 21309 6469 9272 11824 2022 4605 4506
7/31/2021 7480 22808 6948 9812 9972 8167 7057 3038
8/31/2021 2971 11772 5277 20425 11869 9471 3913 2148
9/30/2021 0 22566 5358 16721 17858 1505 9336 9845
10/31/2021 2415 17890 2669 13452 8299 3436 6605 8438
11/30/2021 0 19798 340 19865 10425 8064 6884 4614
12/31/2021 18697 14520 10399 11357 2245 7320 3024 5633
1/31/2022 9885 15114 23367 0 28944 4326 1488 7675
2/28/2022 11316 3768 16908 48 15000 2867 5552 6941
3/31/2022 12578 3599 12146 5073 7810 3578 4703 7489
4/30/2022 3497 250 11747 9256 16500 1574 8832 4772
5/31/2022 14493 0 18546 7747 15263 7276 3186 4553
6/30/2022 13864 469 15772 7502 11786 4170 3452 8514
7/31/2022 20214 19366 17045 0 10195 9399 2745 8430
8/31/2022 7726 0 14161 7981 15510 7281 4489 2546
9/30/2022 6018 8954 17468 1911 22901 2812 8237 1646
10/31/2022 13840 0 24973 2311 24198 3238 8027 6255
11/30/2022 11848 1937 20736 36 19750 3976 2310 6200
12/31/2022 17219 4940 13695 8890 6780 1259 4848 2502
1/31/2023 19539 5984 6060 7418 9846 5991 1412 2753
2/28/2023 7454 4078 8395 24244 16439 8979 3396 3264
3/31/2023 17292 6093 5492 6308 8044 7820 1911 4806
4/30/2023 13580 1185 4697 22975 15000 7912 8824 8866
5/31/2023 20736 1182 2354 16028 11540 4848 6750 5108
6/30/2023 20062 1887 1945 23951 12033 2889 5130 5093
7/31/2023 11566 17143 8572 16873 2824 7965 6874 3852
8/31/2023 20146 3336 3303 13540 10040 4520 5502 7837
9/30/2023 12850 0 7769 10432 17474 1333 3796 1854
10/31/2023 16014 6316 3158 16650 6587 6891 4238 3739
11/30/2023 16650 6033 6326 3998 8618 5782 5587 7029
12/31/2023 10880 4075 5301 21482 11967 8969 2505 4593
1/31/2024 4236 9562 19974 0 21458 1303 5486 4785
2/29/2024 839 6378 18436 10520 24115 5832 5860 2271
3/31/2024 0 12156 22195 5717 22566 7397 7566 7452
4/30/2024 4641 5836 17722 7459 23773 5989 8697 3482
 5/31/2024 0 9381 15184 3644 14305 1120 1798 4518
6/30/2024 1307 13386 13839 7315 9528 3136 5466 6362
7/31/2024 5188 7032 14860 0 16555 1204 5112 5130
8/31/2024 5951 8732 14502 0 17985 1655 8095 2560
9/30/2024 1227 10311 10469 5719 18484 2835 6504 2895
10/31/2024 2404 9160 12569 6362 20330 3328 5622 5918
11/30/2024 3123 0 12414 12568 18640 1401 4400 7581
12/31/2024 8437 2648 13978 0 13191 1121 7151 1116
1/31/2025 10832 18899 5416 12245 5078 4948 5595 2359
2/28/2025 2237 22410 1119 20863 10259 2415 8818 8735
3/31/2025 14522 19384 7261 13766 4657 6912 8636 5281
4/30/2025 2058 22938 3932 15074 13342 7572 5801 1371
5/31/2025 0 25108 4628 16820 17423 3684 3713 8832
6/30/2025 0 14986 14624 18245 7229 9646 4983 6957
7/31/2025 720 14948 23626 15432 4339 9887 4630 2553
8/31/2025 0 14641 19920 13182 3028 6715 4564 2767
9/30/2025 16527 23033 13798 5076 8263 9106 1305 9259
10/31/2025 432 14470 16390 8723 960 3521 3571 2726
11/30/2025 1883 15682 23390 13666 3854 6689 5849 2098
12/31/2025 11693 5184 19835 5550 7325 7253 5846 8205
Seller 4 Seller 5 Seller 6 Seller 7 Seller 8 Seller 9 Seller 10 Year Quarter https://excelt
1002 1000 1000 1003 1000 1000 1000 2020 1
1002 1000 1000 1003 1000 1000 1000 2020 2
1002 1000 1000 1003 1000 1000 1000 2020 3
1002 1000 1000 1003 1000 1000 1000 2020 4
3323 6378 3909 9959 1999 9367 6402 2021 1
9146 6399 4218 6240 1641 2258 5683 2021 1
8858 3125 1649 3738 7075 1855 3054 2021 1
3072 6433 4528 5206 5703 2293 7090 2021 2
2020 3197 2387 7198 9425 1562 1311 2021 2
9176 8166 5904 5539 6726 4444 2185 2021 2
3392 7018 5740 1957 7978 5836 6837 2021 3
3022 2190 6135 9119 8544 6439 1333 2021 3
1719 9400 3488 5441 7793 9794 4182 2021 3
1440 4142 4723 1124 2834 8167 3816 2021 4
1486 5060 5899 5215 2433 5782 4991 2021 4
7845 6360 9241 1568 4556 5071 6600 2021 4
9658 8946 9664 9797 7981 7990 9784 2022 1
3878 5868 4937 5993 1345 8374 1285 2022 1
3645 2578 8385 2842 2108 3395 2483 2022 1
3097 2841 4740 5307 1354 7662 1070 2022 2
9396 7266 5840 2580 4899 2977 8075 2022 2
5100 3441 2755 4679 3719 7242 6321 2022 2
8655 8654 1824 5695 8468 6399 6552 2022 3
3343 3471 6525 9992 2331 2099 3301 2022 3
4805 7868 3299 9160 6339 9269 3816 2022 3
9237 7456 3587 8102 8751 4562 6107 2022 4
9240 7904 1470 7957 2518 4547 8184 2022 4
5351 3601 5475 8052 8640 4845 6951 2022 4
6722 1138 3933 1474 5975 9603 9846 2023 1
9397 4920 1724 9109 3713 7100 9008 2023 1
1461 2668 5416 6159 1250 4588 7149 2023 1
7132 2210 1201 2239 2496 6812 9745 2023 2
4005 8376 2873 8129 2903 3911 4939 2023 2
7674 8573 6304 9562 9361 4221 1072 2023 2
2744 1995 3274 7944 8667 5936 7728 2023 3
4778 5118 6525 2166 7676 2512 3731 2023 3
7968 4000 7945 3731 7188 3338 7372 2023 3
1642 7005 5877 4257 3801 4749 6527 2023 4
3281 4422 1321 5395 2831 2933 3045 2023 4
4218 7360 1504 8789 7910 6052 1804 2023 4
8624 9508 5011 4208 4003 3323 8979 2024 1
4390 6275 4641 8224 6892 7664 8239 2024 1
8691 7459 2029 6663 6974 6683 1720 2024 1
9879 3855 4802 7752 6087 4455 4433 2024 2
6838 4224 7091 3985 3496 2500 6943 2024 2
7287 2877 1763 6475 8216 1628 2164 2024 2
1102 5804 3627 5514 7963 4853 3327 2024 3
8189 3429 9503 3965 5450 2879 1447 2024 3
5498 6918 4260 9044 3274 1292 3690 2024 3
2024 3663 8262 2796 7130 7184 4898 2024 4
7443 2524 2806 4878 7258 5357 3097 2024 4
1246 3348 7245 4834 7750 2513 1929 2024 4
9795 2211 2232 5750 3728 6139 9714 2025 1
6544 9785 1220 6125 3068 2539 7640 2025 1
2697 5436 8458 4127 2767 8195 7081 2025 1
5481 6956 5848 9534 7147 5785 1849 2025 2
9636 4714 6692 2719 8585 5588 9815 2025 2
5362 4433 4808 3803 4317 6354 4420 2025 2
3772 6005 7418 6319 5868 6993 5621 2025 3
7251 6426 5259 2633 5844 7547 1765 2025 3
7842 8145 9382 2795 7240 8783 2840 2025 3
5109 3080 5906 4704 3246 2355 6757 2025 4
7474 7407 3464 4872 3382 9681 7558 2025 4
3405 2798 9258 5835 1789 2354 2844 2025 4
https://exceltable.com/en/templates/dashboard-for-analyzing-sales-ranking
ng-sales-ranking
 Share of Sellers Top 3 Sellers Rank Product Rank
96 24 96% 80 15 7 23 11
81 39 81% 60 15 7 100 11
100 20 100% 100 15 7 33 11
7 80 11
Plan Sales by Quarters Year 7 67 11
76 24 76% 2021 1
100 0 100% Quarters Fact Sales Shares
82 18 82% I 152800 76
61 39 61% II 151212 100
III 171837 82
Top 3 Sellers by ALL Time 2021 Rank Share IV 152371 61
Top Seller 1 342980 Seller 7 57406 1 100

Top Seller 2 340513 Seller 4 46734 3 81 https://exceltable.com/e

Top Seller 3 326827 Seller 5 55306 2 96
2021
Seller 1 Seller 2 Seller 3 Seller 4 Seller 5 Seller 6 Seller 7 Seller 8 Seller 9 Seller 10
50650 52969 54033 46734 55306 40958 57406 59884 46848 41077
ALL Time
Seller 1 Seller 2 Seller 3 Seller 4 Seller 5 Seller 6 Seller 7 Seller 8 Seller 9 Seller 10
310794 319344 315248 340513 326827 299204 342980 324405 320628 312149

Quarters Product A Product B Product C Product D Product E

1 10112 49778 18730 36800 37380
2 6886 48504 18533 37201 40088
3 10451 57146 17583 46958 39699
4 21112 52208 13408 44674 20969
total 48561 207636 68254 165633 138136
ct Rank 23%
A
100%
B
33%
C
80%
D
67%
E
Plans
2020 2021 2022 2023 2024 2025
1000 200000 180000 160000 200000 170000
1000 150000 170000 180000 150000 180000
1000 210000 200000 200000 150000 190000
1000 250000 180000 210000 170000 200000

exceltable.com/en/templates/dashboard-for-analyzing-sales-ranking
https://exceltable.com/en/templates/dashboard-for
tes/dashboard-for-analyzing-sales-ranking