Top 2 Brands - Pivot Table

[Purushothaman]

Hi Experts,

Need your help on the below requirement on a Pivot Table.

Below is the Dataset;

COUNTRY_ABB	BRAND	YEAR	MONTH	PERIOD	SalesUSD
AU	RollsRoyce	2019	Jan	Jan-19	5328
AU	RollsRoyce	2019	Jan	Jan-19	9518
AU	RollsRoyce	2019	Feb	Feb-19	5791
AU	RollsRoyce	2019	Feb	Feb-19	8586
AU	RollsRoyce	2019	Mar	Mar-19	9605
AU	RollsRoyce	2019	Mar	Mar-19	9148
AU	RollsRoyce	2018	Jan	Jan-18	8554
AU	RollsRoyce	2018	Jan	Jan-18	9601
AU	RollsRoyce	2018	Feb	Feb-18	7895
AU	RollsRoyce	2018	Feb	Feb-18	8632
AU	RollsRoyce	2018	Mar	Mar-18	8506
AU	RollsRoyce	2018	Mar	Mar-18	8656
AU	RollsRoyce	2020	Jan	Jan-20	8622
AU	RollsRoyce	2020	Jan	Jan-20	8284
AU	RollsRoyce	2020	Feb	Feb-20	9052
AU	RollsRoyce	2020	Feb	Feb-20	8432
AU	RollsRoyce	2020	Mar	Mar-20	9106
AU	RollsRoyce	2020	Mar	Mar-20	9611
AU	Audi	2019	Jan	Jan-19	9023
AU	Audi	2019	Jan	Jan-19	8149
AU	Audi	2019	Feb	Feb-19	9654
AU	Audi	2019	Feb	Feb-19	8780
AU	Audi	2019	Mar	Mar-19	8260
AU	Audi	2019	Mar	Mar-19	9074
AU	Audi	2018	Jan	Jan-18	7975
AU	Audi	2018	Jan	Jan-18	8358
AU	Audi	2018	Feb	Feb-18	9616
AU	Audi	2018	Feb	Feb-18	9060
AU	Audi	2018	Mar	Mar-18	9496
AU	Audi	2018	Mar	Mar-18	8191
AU	Audi	2020	Jan	Jan-20	8531
AU	Audi	2020	Jan	Jan-20	8050
AU	Audi	2020	Feb	Feb-20	8432
AU	Audi	2020	Feb	Feb-20	9310
AU	Audi	2020	Mar	Mar-20	8866
AU	Audi	2020	Mar	Mar-20	8247
AU	Benz	2019	Jan	Jan-19	8840
AU	Benz	2019	Jan	Jan-19	9093
AU	Benz	2019	Feb	Feb-19	8245
AU	Benz	2019	Feb	Feb-19	9221
AU	Benz	2019	Mar	Mar-19	9099
AU	Benz	2019	Mar	Mar-19	9453
AU	Benz	2018	Jan	Jan-18	9155
AU	Benz	2018	Jan	Jan-18	9361
AU	Benz	2018	Feb	Feb-18	7899
AU	Benz	2018	Feb	Feb-18	8356
AU	Benz	2018	Mar	Mar-18	8174
AU	Benz	2018	Mar	Mar-18	8116
AU	Benz	2020	Jan	Jan-20	8529
AU	Benz	2020	Jan	Jan-20	8843
AU	Benz	2020	Feb	Feb-20	8076
AU	Benz	2020	Feb	Feb-20	9022
AU	Benz	2020	Mar	Mar-20	8384
AU	Benz	2020	Mar	Mar-20	8092
AU	TOYOTA	2019	Jan	Jan-19	1896
AU	TOYOTA	2019	Jan	Jan-19	2440
AU	TOYOTA	2019	Feb	Feb-19	3100
AU	TOYOTA	2019	Feb	Feb-19	2730
AU	TOYOTA	2019	Mar	Mar-19	3433
AU	TOYOTA	2019	Mar	Mar-19	1801
AU	TOYOTA	2018	Jan	Jan-18	2490
AU	TOYOTA	2018	Jan	Jan-18	2812
AU	TOYOTA	2018	Feb	Feb-18	2222
AU	TOYOTA	2018	Feb	Feb-18	2814
AU	TOYOTA	2018	Mar	Mar-18	2668
AU	TOYOTA	2018	Mar	Mar-18	2876
AU	TOYOTA	2020	Jan	Jan-20	1594
AU	TOYOTA	2020	Jan	Jan-20	1995
AU	TOYOTA	2020	Feb	Feb-20	1918
AU	TOYOTA	2020	Feb	Feb-20	1569
AU	TOYOTA	2020	Mar	Mar-20	2568
AU	TOYOTA	2020	Mar	Mar-20	2685
AU	NISSAN	2019	Jan	Jan-19	2281
AU	NISSAN	2019	Jan	Jan-19	3043
AU	NISSAN	2019	Feb	Feb-19	2028
AU	NISSAN	2019	Feb	Feb-19	2370
AU	NISSAN	2019	Mar	Mar-19	3465
AU	NISSAN	2019	Mar	Mar-19	1917
AU	NISSAN	2018	Jan	Jan-18	2367
AU	NISSAN	2018	Jan	Jan-18	2544
AU	NISSAN	2018	Feb	Feb-18	3024
AU	NISSAN	2018	Feb	Feb-18	3203
AU	NISSAN	2018	Mar	Mar-18	2767
AU	NISSAN	2018	Mar	Mar-18	2070
AU	NISSAN	2020	Jan	Jan-20	2083
AU	NISSAN	2020	Jan	Jan-20	2547
AU	NISSAN	2020	Feb	Feb-20	1676
AU	NISSAN	2020	Feb	Feb-20	1605
AU	NISSAN	2020	Mar	Mar-20	3099
AU	NISSAN	2020	Mar	Mar-20	2658
AU	MAZADA	2019	Jan	Jan-19	1977
AU	MAZADA	2019	Jan	Jan-19	3431
AU	MAZADA	2019	Feb	Feb-19	1658
AU	MAZADA	2019	Feb	Feb-19	2388
AU	MAZADA	2019	Mar	Mar-19	1513
AU	MAZADA	2019	Mar	Mar-19	2057
AU	MAZADA	2018	Jan	Jan-18	1652
AU	MAZADA	2018	Jan	Jan-18	2560
AU	MAZADA	2018	Feb	Feb-18	1706
AU	MAZADA	2018	Feb	Feb-18	2041
AU	MAZADA	2018	Mar	Mar-18	2162
AU	MAZADA	2018	Mar	Mar-18	2299
AU	MAZADA	2020	Jan	Jan-20	1837
AU	MAZADA	2020	Jan	Jan-20	2280
AU	MAZADA	2020	Feb	Feb-20	2765
AU	MAZADA	2020	Feb	Feb-20	2886
AU	MAZADA	2020	Mar	Mar-20	3494
AU	MAZADA	2020	Mar	Mar-20	3491
VN	RollsRoyce	2019	Jan	Jan-19	2208
VN	RollsRoyce	2019	Jan	Jan-19	1717
VN	RollsRoyce	2019	Feb	Feb-19	1792
VN	RollsRoyce	2019	Feb	Feb-19	1981
VN	RollsRoyce	2019	Mar	Mar-19	1597
VN	RollsRoyce	2019	Mar	Mar-19	2776
VN	RollsRoyce	2018	Jan	Jan-18	2919
VN	RollsRoyce	2018	Jan	Jan-18	1825
VN	RollsRoyce	2018	Feb	Feb-18	2577
VN	RollsRoyce	2018	Feb	Feb-18	3389
VN	RollsRoyce	2018	Mar	Mar-18	1979
VN	RollsRoyce	2018	Mar	Mar-18	2291
VN	RollsRoyce	2020	Jan	Jan-20	2994
VN	RollsRoyce	2020	Jan	Jan-20	2712
VN	RollsRoyce	2020	Feb	Feb-20	3075
VN	RollsRoyce	2020	Feb	Feb-20	3126
VN	RollsRoyce	2020	Mar	Mar-20	2522
VN	RollsRoyce	2020	Mar	Mar-20	3461
VN	Audi	2019	Jan	Jan-19	1670
VN	Audi	2019	Jan	Jan-19	2350
VN	Audi	2019	Feb	Feb-19	1836
VN	Audi	2019	Feb	Feb-19	3393
VN	Audi	2019	Mar	Mar-19	2419
VN	Audi	2019	Mar	Mar-19	3083
VN	Audi	2018	Jan	Jan-18	2921
VN	Audi	2018	Jan	Jan-18	2852
VN	Audi	2018	Feb	Feb-18	2655
VN	Audi	2018	Feb	Feb-18	2529
VN	Audi	2018	Mar	Mar-18	2669
VN	Audi	2018	Mar	Mar-18	2406
VN	Audi	2020	Jan	Jan-20	2180
VN	Audi	2020	Jan	Jan-20	1796
VN	Audi	2020	Feb	Feb-20	2785
VN	Audi	2020	Feb	Feb-20	3371
VN	Audi	2020	Mar	Mar-20	2330
VN	Audi	2020	Mar	Mar-20	1797
VN	Benz	2019	Jan	Jan-19	2788
VN	Benz	2019	Jan	Jan-19	2404
VN	Benz	2019	Feb	Feb-19	2315
VN	Benz	2019	Feb	Feb-19	3388
VN	Benz	2019	Mar	Mar-19	1851
VN	Benz	2019	Mar	Mar-19	2982
VN	Benz	2018	Jan	Jan-18	2893
VN	Benz	2018	Jan	Jan-18	3246
VN	Benz	2018	Feb	Feb-18	3379
VN	Benz	2018	Feb	Feb-18	2364
VN	Benz	2018	Mar	Mar-18	1899
VN	Benz	2018	Mar	Mar-18	1511
VN	Benz	2020	Jan	Jan-20	1686
VN	Benz	2020	Jan	Jan-20	2904
VN	Benz	2020	Feb	Feb-20	3032
VN	Benz	2020	Feb	Feb-20	2773
VN	Benz	2020	Mar	Mar-20	1675
VN	Benz	2020	Mar	Mar-20	2808
VN	TOYOTA	2019	Jan	Jan-19	2734
VN	TOYOTA	2019	Jan	Jan-19	2853
VN	TOYOTA	2019	Feb	Feb-19	2128
VN	TOYOTA	2019	Feb	Feb-19	2257
VN	TOYOTA	2019	Mar	Mar-19	3278
VN	TOYOTA	2019	Mar	Mar-19	2819
VN	TOYOTA	2018	Jan	Jan-18	2782
VN	TOYOTA	2018	Jan	Jan-18	2698
VN	TOYOTA	2018	Feb	Feb-18	3010
VN	TOYOTA	2018	Feb	Feb-18	3341
VN	TOYOTA	2018	Mar	Mar-18	1687
VN	TOYOTA	2018	Mar	Mar-18	3197
VN	TOYOTA	2020	Jan	Jan-20	2485
VN	TOYOTA	2020	Jan	Jan-20	1536
VN	TOYOTA	2020	Feb	Feb-20	3418
VN	TOYOTA	2020	Feb	Feb-20	2366
VN	TOYOTA	2020	Mar	Mar-20	2702
VN	TOYOTA	2020	Mar	Mar-20	3469
VN	NISSAN	2019	Jan	Jan-19	2387
VN	NISSAN	2019	Jan	Jan-19	1596
VN	NISSAN	2019	Feb	Feb-19	3057
VN	NISSAN	2019	Feb	Feb-19	1793
VN	NISSAN	2019	Mar	Mar-19	3199
VN	NISSAN	2019	Mar	Mar-19	2967
VN	NISSAN	2018	Jan	Jan-18	3344
VN	NISSAN	2018	Jan	Jan-18	3456
VN	NISSAN	2018	Feb	Feb-18	3384
VN	NISSAN	2018	Feb	Feb-18	2113
VN	NISSAN	2018	Mar	Mar-18	3356
VN	NISSAN	2018	Mar	Mar-18	2819
VN	NISSAN	2020	Jan	Jan-20	2536
VN	NISSAN	2020	Jan	Jan-20	3293
VN	NISSAN	2020	Feb	Feb-20	3465
VN	NISSAN	2020	Feb	Feb-20	1778
VN	NISSAN	2020	Mar	Mar-20	2204
VN	NISSAN	2020	Mar	Mar-20	2947
VN	MAZADA	2019	Jan	Jan-19	2952
VN	MAZADA	2019	Jan	Jan-19	2702
VN	MAZADA	2019	Feb	Feb-19	2993
VN	MAZADA	2019	Feb	Feb-19	1625
VN	MAZADA	2019	Mar	Mar-19	3306
VN	MAZADA	2019	Mar	Mar-19	2461
VN	MAZADA	2018	Jan	Jan-18	2427
VN	MAZADA	2018	Jan	Jan-18	3178
VN	MAZADA	2018	Feb	Feb-18	1730
VN	MAZADA	2018	Feb	Feb-18	2275
VN	MAZADA	2018	Mar	Mar-18	3443
VN	MAZADA	2018	Mar	Mar-18	2071
VN	MAZADA	2020	Jan	Jan-20	1696
VN	MAZADA	2020	Jan	Jan-20	1806
VN	MAZADA	2020	Feb	Feb-20	2767
VN	MAZADA	2020	Feb	Feb-20	2814
VN	MAZADA	2020	Mar	Mar-20	3136
VN	MAZADA	2020	Mar	Mar-20	3161
NZ	RollsRoyce	2019	Jan	Jan-19	1649
NZ	RollsRoyce	2019	Jan	Jan-19	3298
NZ	RollsRoyce	2019	Feb	Feb-19	2134
NZ	RollsRoyce	2019	Feb	Feb-19	2320
NZ	RollsRoyce	2019	Mar	Mar-19	2031
NZ	RollsRoyce	2019	Mar	Mar-19	3327
NZ	RollsRoyce	2018	Jan	Jan-18	1946
NZ	RollsRoyce	2018	Jan	Jan-18	1902
NZ	RollsRoyce	2018	Feb	Feb-18	3068
NZ	RollsRoyce	2018	Feb	Feb-18	1650
NZ	RollsRoyce	2018	Mar	Mar-18	1798
NZ	RollsRoyce	2018	Mar	Mar-18	1635
NZ	RollsRoyce	2020	Jan	Jan-20	2591
NZ	RollsRoyce	2020	Jan	Jan-20	1699
NZ	RollsRoyce	2020	Feb	Feb-20	2913
NZ	RollsRoyce	2020	Feb	Feb-20	3449
NZ	RollsRoyce	2020	Mar	Mar-20	3150
NZ	RollsRoyce	2020	Mar	Mar-20	2765
NZ	Audi	2019	Jan	Jan-19	3079
NZ	Audi	2019	Jan	Jan-19	3323
NZ	Audi	2019	Feb	Feb-19	3265
NZ	Audi	2019	Feb	Feb-19	3484
NZ	Audi	2019	Mar	Mar-19	1656
NZ	Audi	2019	Mar	Mar-19	1795
NZ	Audi	2018	Jan	Jan-18	2080
NZ	Audi	2018	Jan	Jan-18	2909
NZ	Audi	2018	Feb	Feb-18	1559
NZ	Audi	2018	Feb	Feb-18	1885
NZ	Audi	2018	Mar	Mar-18	2462
NZ	Audi	2018	Mar	Mar-18	2723
NZ	Audi	2020	Jan	Jan-20	2178
NZ	Audi	2020	Jan	Jan-20	2774
NZ	Audi	2020	Feb	Feb-20	2784
NZ	Audi	2020	Feb	Feb-20	1920
NZ	Audi	2020	Mar	Mar-20	2862
NZ	Audi	2020	Mar	Mar-20	2657
NZ	Benz	2019	Jan	Jan-19	3333
NZ	Benz	2019	Jan	Jan-19	1705
NZ	Benz	2019	Feb	Feb-19	3336
NZ	Benz	2019	Feb	Feb-19	2437
NZ	Benz	2019	Mar	Mar-19	2264
NZ	Benz	2019	Mar	Mar-19	1677
NZ	Benz	2018	Jan	Jan-18	3423
NZ	Benz	2018	Jan	Jan-18	1966
NZ	Benz	2018	Feb	Feb-18	3480
NZ	Benz	2018	Feb	Feb-18	1861
NZ	Benz	2018	Mar	Mar-18	1961
NZ	Benz	2018	Mar	Mar-18	2362
NZ	Benz	2020	Jan	Jan-20	3452
NZ	Benz	2020	Jan	Jan-20	3007
NZ	Benz	2020	Feb	Feb-20	3355
NZ	Benz	2020	Feb	Feb-20	2200
NZ	Benz	2020	Mar	Mar-20	1726
NZ	Benz	2020	Mar	Mar-20	1581
NZ	TOYOTA	2019	Jan	Jan-19	745
NZ	TOYOTA	2019	Jan	Jan-19	809
NZ	TOYOTA	2019	Feb	Feb-19	647
NZ	TOYOTA	2019	Feb	Feb-19	506
NZ	TOYOTA	2019	Mar	Mar-19	678
NZ	TOYOTA	2019	Mar	Mar-19	526
NZ	TOYOTA	2018	Jan	Jan-18	945
NZ	TOYOTA	2018	Jan	Jan-18	571
NZ	TOYOTA	2018	Feb	Feb-18	923
NZ	TOYOTA	2018	Feb	Feb-18	511
NZ	TOYOTA	2018	Mar	Mar-18	685
NZ	TOYOTA	2018	Mar	Mar-18	683
NZ	TOYOTA	2020	Jan	Jan-20	777
NZ	TOYOTA	2020	Jan	Jan-20	799
NZ	TOYOTA	2020	Feb	Feb-20	746
NZ	TOYOTA	2020	Feb	Feb-20	830
NZ	TOYOTA	2020	Mar	Mar-20	620
NZ	TOYOTA	2020	Mar	Mar-20	773
NZ	NISSAN	2019	Jan	Jan-19	616
NZ	NISSAN	2019	Jan	Jan-19	1234
NZ	NISSAN	2019	Feb	Feb-19	1437
NZ	NISSAN	2019	Feb	Feb-19	1385
NZ	NISSAN	2019	Mar	Mar-19	1588
NZ	NISSAN	2019	Mar	Mar-19	1423
NZ	NISSAN	2018	Jan	Jan-18	1556
NZ	NISSAN	2018	Jan	Jan-18	1338
NZ	NISSAN	2018	Feb	Feb-18	1170
NZ	NISSAN	2018	Feb	Feb-18	1121
NZ	NISSAN	2018	Mar	Mar-18	1594
NZ	NISSAN	2018	Mar	Mar-18	1345
NZ	NISSAN	2020	Jan	Jan-20	1158
NZ	NISSAN	2020	Jan	Jan-20	1261
NZ	NISSAN	2020	Feb	Feb-20	1377
NZ	NISSAN	2020	Feb	Feb-20	1170
NZ	NISSAN	2020	Mar	Mar-20	1359
NZ	NISSAN	2020	Mar	Mar-20	1342
NZ	MAZADA	2019	Jan	Jan-19	1905
NZ	MAZADA	2019	Jan	Jan-19	1965
NZ	MAZADA	2019	Feb	Feb-19	1865
NZ	MAZADA	2019	Feb	Feb-19	1781
NZ	MAZADA	2019	Mar	Mar-19	2018
NZ	MAZADA	2019	Mar	Mar-19	2010
NZ	MAZADA	2018	Jan	Jan-18	2077
NZ	MAZADA	2018	Jan	Jan-18	1975
NZ	MAZADA	2018	Feb	Feb-18	2096
NZ	MAZADA	2018	Feb	Feb-18	1807
NZ	MAZADA	2018	Mar	Mar-18	1867
NZ	MAZADA	2018	Mar	Mar-18	1741
NZ	MAZADA	2020	Jan	Jan-20	2094
NZ	MAZADA	2020	Jan	Jan-20	1825
NZ	MAZADA	2020	Feb	Feb-20	2077
NZ	MAZADA	2020	Feb	Feb-20	2023
NZ	MAZADA	2020	Mar	Mar-20	2069
NZ	MAZADA	2020	Mar	Mar-20	1762

[EdgarOlmos · Accepted solution]

Hi.
Here is an example how you can do it.
Regards

[Iswarya_ · Accepted solution]

Hi @Purushothaman ,

Attaching solution below for reference.