Bottom 20% count

[naveen_kunuru]

Hello All,

I am trying to show  count of distinct bottom 20%  codes in a KPI

same i have tried and succeed in combo chart but not able to show in KPI object

In Combo chart

Dimension : Code

Expression :  

If(RangeSum(Above(Sum(d_OP),0,RowNo()))
<
(Sum(TOTAL d_OP)*20/100),sum(d_OP),0)

Expression %:

If(RangeSum(Above(Sum(d_OP),0,RowNo()))
<
(Sum(TOTAL d_OP)*20/100),(sum(d_OP)/sum(total d_OP))*100,0)

sorting : Code--->Expression:sum(d_OP) --->Ascending

But for KPI i am confuse how to write a expression which sort and get bottom 20 % codes count

Attaching the out put file of my Bottom 20 % Combo chart where distinct codes count is 535.

Need to show the same value in KPI

[naveen_kunuru]

Any suggestion on this plz