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


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




      Any help is appreciated