2 Replies Latest reply on Aug 30, 2013 3:19 PM by jaimie.stark

    Additional Subotals and Grand Totals with Percentage

    jaimie.stark

      I have a text table with a summary of headcount by Division and Department. I need to add:

      Additional Subtotal Row with % of Division

      Additional Row Grand Total with Department % of Division

      Additional Column Grand Total with Role % of Organization

       

      Desired result:

      Totals Example.png

      I was able to add an additional subtotal row (labeled 'Total % of Division) by following a solution in another post however was not successful in displaying percentage.I've attached an example workbook.

       

      Any assistance would be very much appreciated! Thanks!