Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi ,
If i want to show percentile as 10-20%,20-30%,30,40%.........90-100%.?
How i can achieve this.
Can you help me on this.