2 Replies Latest reply on Feb 27, 2018 4:25 AM by Thomas Beaulieu

    Calculations with multiple revenue columns

    Thomas Beaulieu

      Hello - I have data that is arranged in an excel table as shown below.

       

      I want each cell to show a percentage of the grand total for the entire table, preferably in a heat map format.  The table grand total is $2,042,456 which means that the cell formed by the intersection of Chemical and NA should read 3.4% or a heat map color indicative of a real small value, like red.

       

      I cannot figure out how to do this based on the table grand total, I have only figured this out for row or column grand totals.  Any help is much appreciated.

       

      I have attached a packaged workbook as a sample.

       

      Thanks,

      Tom