conditional formatting with percentage values and percentile colors

[rdsuperlike]

Hi,

I want to create a table in qlikview as below but for each date (row) I want the cell to show the percentage value.  ex:for 5/12/2014 level 1 should show 12/12+50+75 = 12/137 = 8.75%. I could do this part.

But i couldnt do the next part where I want to calculate percentile.

each row(at date level) should show 3 color gradient in form of percentile/fractile function ex: green..yellow..red from 0 to 100%

Date	Level	0	1	2	3	4	5
5/12/2014		-	12	50	-	75	-
5/19/2014		-	322	289	74	50	22
5/26/2014		-	202	75	2	239	201
6/2/2014		-	229	214	118	298	123
6/9/2014		-	1,006	364	49	237	220
6/16/2014		-	2,346	175	219	195	25
6/23/2014		-	3,847	124	196	321	24

i have attached the spreadsheet and app