1 Reply Latest reply on May 7, 2013 5:07 PM by Shawn Wallwork

    How to get each column as pct of total for that row

    bruce lomasky

      I have a grid with Inventory SKUs on each row and sizes (S,M, L, XL) on each column. In each cell is the total sales (qty) for each SKU / Size.  I want to have the PCT of total displayed in each cell and am confused on the calculated field to give me that result.  If I am not explaining this well, my table now looks like this:

       

                     S          M          L          XL

      item 1     10          20          30     20

       

      I want the table to have

                      12.5%     25%     37.5%     25%

       

       

      Thank you

      Bruce