In different views I need to check as of now try this approach to see both top 100 and bottom 100 in same view, if possible tweak it.
Use 2 columns with expressions
and then hide BottomN(#sales, 5) column and set order on sales with this you may see 200 records
logical query something like below
select TOPN(#Sales, 5), BottomN(#sales, 5), #sales from subjectArea
if helps mark