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 -





      DESIRE - Show this as





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