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

    Row wise Percentage Columns to table view

    bharat sagi



      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.