4 Replies Latest reply on Sep 30, 2016 5:51 PM by Shinichiro Murakami

    Create a "Percent Of" calculation instead of "Percent Difference"

    Derek Manning

      I have a data table where all of the columns are a subset of a single total, which is the first column.  When I use the "Percent Difference" Table calculation it shows all the subsequent columns in a negative percentage, all below 0 obviously.  I was the chart to show what the percentage of each column is compared to the first column.

       

      Example -

      First Column Count = 100

      Second Column Count = 50

      Third Column Count = 25

      Fourth Column Count = 10

       

      Percent Difference Calculation Shows -

      -50%

      -75%

      -90%

       

      DESIRE - Show this as

      50%

      25%

      20%

       

      Essentially I want to show the inverse of the Percent Difference Calculation.  Any ideas?