Rank function to suppress zero values

[#1]

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

[#2]

Try to use Dimension Limits( Dimension Limit Tab).

Choose show only "Smallest" 10 and in "Presentation tab" Uncheck ""Suppress Zero-values"

I think it will solve your problem.

[#3]

Unfortunatelly the customer is with v10 so dimension limits is not an option