4 Replies Latest reply on Nov 15, 2016 8:49 AM by Tableau User Branched to a new discussion.

    How to add a 'Percentage of' to only one column in a table

    . Mar

      I have a table with 8 columns, The 1 st column shows a demension, the other 7 columns show various measures.

      I need to add a column that would show a 'percentage of Totals' fro each row of the second column:

      (number of records per Code/Total records in the column) * 100

       

      When I use Analysis/Percentage of menu, the percentage is applied to all the columns in the table.

       

      Is there a way to create a calculated field to calculate the percentage?

      I don't know how to reference a column's Grand total in a formula - Total records in the column

       

       

      I attached a png file of my table

       

      Thanks