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