Title: Number based sorting issue
Last modified: August 20, 2016

---

# Number based sorting issue

 *  Resolved [njordan1784](https://wordpress.org/support/users/njordan1784/)
 * (@njordan1784)
 * [13 years, 7 months ago](https://wordpress.org/support/topic/number-based-sorting-issue/)
 * Having an issue with the sort feature on the table. It isn’t sorting by numerical
   order. For instance it is putting 10 and 11 before 3 and 4. Is there an option
   I’m missing?
 * This was a csv imported file from google drive if that makes a difference.
 * [http://wordpress.org/extend/plugins/wp-table-reloaded/](http://wordpress.org/extend/plugins/wp-table-reloaded/)

Viewing 7 replies - 1 through 7 (of 7 total)

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [13 years, 7 months ago](https://wordpress.org/support/topic/number-based-sorting-issue/#post-3151376)
 * Hi,
 * the reason for this likely is that not all of the cells in that column (except
   for the head row) have plain numerical values in them. Plain numeric value means
   nothing except the numbers from 0 to 9, and the `.` for non-integer values.
    
   If you post the URL to the page with your table, I will gladly take a look and
   check if that is the case here.
 * Regards,
    Tobias
 *  Thread Starter [njordan1784](https://wordpress.org/support/users/njordan1784/)
 * (@njordan1784)
 * [13 years, 7 months ago](https://wordpress.org/support/topic/number-based-sorting-issue/#post-3151427)
 * That must be it. I have percentages in those columns. Any way to display a %?
 * Here is the table (A work in progress).
 * [http://homebrewresource.com/hop-guide/](http://homebrewresource.com/hop-guide/)
 * Thanks!
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [13 years, 7 months ago](https://wordpress.org/support/topic/number-based-sorting-issue/#post-3151433)
 * Hi,
 * thanks for the link. The percentages are indeed the reason for this.
    Fortunately,
   there is a “Plugin Extension” that makes these sortable (just like currency values,
   for examples). To install this, please take a look at the thread [http://wordpress.org/support/topic/plugin-wp-table-reloaded-sorting-numbers-1](http://wordpress.org/support/topic/plugin-wp-table-reloaded-sorting-numbers-1)
   where I explain this.
 * Regards,
    Tobias
 *  Thread Starter [njordan1784](https://wordpress.org/support/users/njordan1784/)
 * (@njordan1784)
 * [13 years, 6 months ago](https://wordpress.org/support/topic/number-based-sorting-issue/#post-3151467)
 * Thanks for the reply Tobias.
 * I installed the extension and added the custom code ” “aoColumnDefs”: [ { “sType”:“
   currency_sorting”, “aTargets”: [ “column-3”, “column-4″ ] } ”
 * to my page. Doing so makes it no longer sortable or searchable at all. I left
   this version on the server for you to view.
 * Any suggestions? Thanks again for your help!
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [13 years, 6 months ago](https://wordpress.org/support/topic/number-based-sorting-issue/#post-3151469)
 * Hi,
 * from what I can see there’s a `]` missing at the end of the code that you inserted.
   Please try again with
 *     ```
       "aoColumnDefs": [ { "sType": "currency_sorting", "aTargets": [ "column-3", "column-4" ] } ]
       ```
   
 * Regards,
    Tobias
 *  Thread Starter [njordan1784](https://wordpress.org/support/users/njordan1784/)
 * (@njordan1784)
 * [13 years, 6 months ago](https://wordpress.org/support/topic/number-based-sorting-issue/#post-3151473)
 * Thanks! That worked.
 * I appreciate your help.
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [13 years, 6 months ago](https://wordpress.org/support/topic/number-based-sorting-issue/#post-3151474)
 * Hi,
 * awesome, thanks for the confirmation! 🙂
 * Best wishes,
    Tobias

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Number based sorting issue’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/wp-table-reloaded_f7dcd3.svg)
 * [WP-Table Reloaded](https://wordpress.org/plugins/wp-table-reloaded/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-table-reloaded/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-table-reloaded/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-table-reloaded/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-table-reloaded/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-table-reloaded/reviews/)

 * 7 replies
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [13 years, 6 months ago](https://wordpress.org/support/topic/number-based-sorting-issue/#post-3151474)
 * Status: resolved