I have a report that list products by gross sale amount and a calculated column 'Rank' that ranks them based on the statement;
"rank([Gross Sale Amount])"
I can then sort the top 20 products by filtering where;
"rank([Gross Sale Amount])<= 20"
I also wish to view only the bottom 20 ranked...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.