2 Replies Latest reply: Oct 15, 2012 8:24 AM by Stefan Stoichev RSS

    Rank function to suppress zero values

      Hi all,

       

      i have an requrement that i should create a straight/pivoit table that should show worst 10 salesmans. I wrote an expression using rank function. But the problem is that rank ignore the suppress zero values check and the table show worst 10 salesmans but including the salesmans without any sales. Which must be excluded from the report.

       

      Is there any way to solve this?

       

      Thanks!

      Stefan