Project       Sales Target   Achievement     % Achievement
            Project 1              77000          70000                   91%
            Project 2              72000          80000                 111%
            Project 3              50000          55000                 110%
            Project 4            100000           95000                   95%
            Project 5              62000          60000                   97%
            Project 6              72000          70000                   97%
            Project 7              93000          95000                 102%
            Project 8              98000          95000                   97%
            Project 9              80000          82000                 103%
            Project 10             55000          50000                   91%
                                                                                           Excel Formula to Calculate Percentage of Grand Total
                        Method 1: Items don't repeat in the column
                        Marketing Channel                  Sales                       % of Grand Total
                        Facebook                             $                15,230                                  12.44%=C6/$C$14
                        Google Adwords                                       25050                                    20.47%=C7/$C$14
                        Organic                                              32000                                    26.15%=C8/$C$14
                        Email Marketing                                      50100                                    40.94%=C9/$C$14
                        Grand Total                         $              122,380                                       100%
                                                           =SUM(C6:C13)
                        Method 2: Items do repeat in the column (Using SUMIF Function)
                        Marketing Channel                  Sales                                   Marketing Channel: Facebook
                        Facebook                             $                  5,000              % of Grand Total:                                             28%
                        Google AdWords                                         2500                       E20=SUMIF(B20:B33,E19,C20:C33)/$C$34
                        Organic                                                3200
                        Email Marketing                                        5010
                        Outreach                                               5800
                        Facebook                                               4230
                        Organic                                                2358
                        Facebook                                               3323
                        Organic                                                4902
                        Google AdWords                                         3421
                        Google AdWords                                         4757
                                                                                           https://www.exceldemy.com/excel-formula-to-calculate-percentage-of-grand-total/
                        Grand Total                          $                44,501 
                        Formula in cell B21:               =SUM(C20:C33)
Excel Formula to Calculate Percentage of Grand Total
           Method 3: Using Excel Table
           Marketing Channel   Sales                % of Grand Total
           Facebook                           15230            12.44%
           Google Adwords                     25050            20.47%
           Organic                            32000            26.15%
           Email Marketing                    50100            40.94%
           Total                             122380           100.00%
                % of Grand Total  =[@Sales]/Table32[[#Totals],[Sales]]
           Method 4: Showing % of Grand Total in Pivot Table
                               Data
           State_l             Sum - Revenue        Sum - Revenue
           California                  31017385250             22.77%
           Florida                      9012608940               6.62%
           Illinois                    13548067258               9.95%
           Massachusetts                7714875801               5.66%
           Michigan                     7687537169               5.64%
           New York                    11289216207               8.29%
           Ohio                        11051298826               8.11%
           Tennessee                    8153943024               5.99%
           Texas                       27263931736             20.02%
           Virginia                     9475062257               6.96%
           Total Result               136213926468            100.00%
https://www.exceldemy.com/excel-formula-to-calculate-percentage-of-grand-total/
            Marketing Channel       Sales              Marketing Channel:       Outreach
            Facebook                 $       5,000        % of Grand Total:                                          9%
            Google AdWords                 2500
            Organic                        3200
            Email Marketing                5010
            Outreach                       5800
            Facebook                       4230
            Organic                        2358
            Facebook                       3323
            Organic                        4902
            Google AdWords                 3421
            Google AdWords                 4757
            Organic                        3392
            Facebook                       2807
            Organic                        4336
            Google AdWords                 3624
            Facebook                       3040
            Grand Total              $     61,700 
            Formula in cell B21:    =SUM(B2:B20)