This content has been marked as final. Show 2 replies
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?