Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Hi.
Here is an example how you can do it.
Regards