2 Replies Latest reply on Dec 1, 2015 9:01 AM by dave.cook

    How do I calculate the average on a set of percent of totals?

    dave.cook

      I have a bar chart that displays the % of total for a set of dimensions.  The test data is survey responses for a set a questions.  How do I display the average for each response based on all 7 questions.  For example, I would like to average all 7 values and display a bar showing 85.7%.  I have attached my test packaged workbook.

       

      Snap53.jpg