Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Something like the attached?
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)
maybe here