0 Replies Latest reply: Oct 13, 2015 5:41 PM by ria Desai RSS

    heat map-percentile

    ria Desai

      I am trying to calculate percentile and use colormix wizard.

       

      I am using rank function here.

       

      When i use it on straught table it works fine. But as soon as I drag the blue arrow on the column(steps) and put it horizontally, it messes up.

       

      I have attcahed the example and qvw.

       

       

      I want pivot table with two dimensions as the crosstab.

      Date Steps 40 39 38 37 35------ and so on

      1/5

      2/5         Qtys in the cell value and percentile values for colors

      3/5

      4/5

       

      Any help is appreciated