User Listing : How to query the database

Hi, I am new to Profile Builder. I hope I am trying to make the all-userlisting page sort. I don’t want the visitor to the website to have the capability to search I just want to present a table showing results.

here is the code;

<table class=”wppb-table”>
<thead>
<tr>
<th>State Ranking</td>
<th>Name</td>
<th>Company</td>
<th>Office Location</td>
<th>State</td>
<th>Zone</td>
<th>Sales Volume 2019</td>
<th>Market Specialization</td>
<th>See Profile</td>
</tr>
</thead>
<tbody>
{{#users}}
<tr>
<td data-label=”State Ranking” class=”wppb-ranking”>{{meta_custom_field_14}}</td>
<td data-label=”Firstname” class=”wppb-name”>{{meta_first_name}} {{meta_last_name}}</td>
<td data-label=”Companyname” class=”wppb-company”>meta_custom_field_1</td>
<td data-label=”Office Location” class=”wppb-office”>meta_custom_field_15</td>
<td data-label=”State” class=”wppb-office”>meta_custom_field_10</td>
<td data-label=”Zone” class=”wppb-office”>meta_custom_field_17</td>
<td data-label=”Sales Volume” class=”wppb-sales”>meta_custom_field_7</td>
<td data-label=”Market Specialization” class=”wppb-msa”>meta_custom_field_11</td>
<td data-label=”More” class=”wppb-moreinfo”>more_info</td>
</tr>
{{/users}}
</tbody>
</table>
pagination

The Sales Volume dictates the ranking, so that needs to be dynamic. The State and zone dictate the location. I am creating a user listing page for each state and zones within that state. States are just prefixes (CA, TX etc,) and zones are (1,2, 3) Is it possible to write the code for this and just place it in the all-userlisting code? Or, is this needs to be done somewhere else. All answers are greatly appreciated ~creedsd

The page I need help with: [log in to see the link]