Rank top 30% in expression

[#1]

Hi,

I'm attempting to create an expression that will return a value of 1 if the Rank of the values in the expression is in the top 30% and 0 if it is not

The current expression returns the sum of sales for each employee and this is what the rank should be based upon.

Can someone please point me in the right direction,, how to write what expression(s), what function should be used?

Thanks in advance

Brian

[chrismarlow]

Something like the attached?

[jzimolong]

Make sure your chart is sorted by sales in descending order, then perhaps this expression will work:

=if((rangesum(above(sum([Sales]),0,rowno())))<(sum(TOTAL Sales) * .3),1,0)

[maxgro]

maybe here

Recipe for an ABC Analysis