Top 20 Bottom 20

[theroc]

Trying to id the top 20 parts based of sales $, which I can do with the rank function, having a hard time getting the bottom 20 base off $.....any help would be great thanks.

[rockytopmark]

Add a calculated column; [Sales $] * -1 ...then apply rank to that. for the bottom 20

[theroc]

Thanks makes sense....it has been a long day and that is so obvious now  >:(