1 Reply Latest reply on Jul 29, 2016 8:48 AM by hannah.johnson

    create a summary column with percentile

    Keith Lee

      Hi all,

       

      I would like to create a table with percentile values of each column. End result would look like

       

                                  X     Y     Z

      5% Percentile     0.1  0.3  0.5

      10% Percentile   0.7  0.9  3.5

      15% Percentile   0.9  1.1  7.5

       

      and so on. all the way to 100% Percentile. X, Y, Z can be sth like Sales, Revenue, etc etc

        • 1. Re: create a summary column with percentile
          hannah.johnson

          Create custom calculated fields called, "5% Percentile", "10% Percentile, "15% Percentile, etc.

          Use the following formula for each calculated field:

          PERCENTILE(<measure>, <percent>)

           

          So for "5% Percentile, your calculation may look like this...

          PERCENTILE([Sales], .5)

           

          Next, place your "X,Y,Z" dimension on Columns, Measure Names on Rows, and Measure Values on Text on the Marks Card.

          Add only the custom Percentile calculations to the Measure Values card.