1 Reply Latest reply on Feb 6, 2013 1:29 AM by Jim Wahl

    Row wise Percentage Columns to table view

    bharat sagi

      Hi,

       

      I have attached dataset ( Sample 1).

      I have to add two Percentage columns at the end of this Table

       

      Non producing percentage = ( Non Producing / Total Dlrs ) * 100

      Not enrolled percentage = ( Not enrolled / Total Dlrs ) * 100

       

      When I am adding these columns percenatge is getting calculated for the entire table rather than each individual row.

      Attached the Excel on the expected output ( Sample 2)

       

      Thank you for the support.