COUNTIF in QLIKSENSE

[QS21]

Hi all,

Hoping someone would save me this time.I am looking to replicate the below excel formula in qliksense:

COUNTIF(B$2:B$12,"<="&B2)/COUNT(B$2:B$12)

this is what I have:

NAME	PERC
EDWIN	67%
Dave	33%
SAM	44%
ROB	56%
STEVE	100%
DAN	78%
MIKE	89%
SIMON	11%
MILEY	22%
KATH	75%
CATHY	63%
ROSY	13%

This is what I want:

NAME	PERC	NEED
EDWIN	67%	67%
Dave	33%	33%
SAM	44%	42%
ROB	56%	50%
STEVE	100%	100%
DAN	78%	83%
MIKE	89%	92%
SIMON	11%	8%
MILEY	22%	25%
KATH	75%	75%
CATHY	63%	58%
ROSY	13%	17%

PLEASE HELP!!

[G3S]

by loading only NAME in the straight table, sort by expression: PERC

add column for NEED  in table with expression: Rangesum(above(count ( PERC),0,NoOfRows()))/
noofrows()

 this isn't working when PERC is introduced as a column in the straight table. not sure why.

[QS21]

Thank you! will try this and get back to you..