This post describes how to create tables and charts in Q that automatically sort, from highest to lowest, leaving NET, Total, Other, All of these, None of These, and Don't Know at the bottom of the table. It will also work with crosstabs, performing the sort based on the values in the NET column.


The table below is a standard Displayr table, created by dragging age from Data sets onto the page.


In the table below, it has been automatically sorted, with the NET staying at the bottom. If the data changes (e.g., due to being weighted, or updating the raw data), the table will automatically re-sort. If the table is turned into a chart, it will still continue to be automatically sorted.

How to make a table auto-sort in Displayr

The process for getting a table in Displayr to auto-sort is:

  1. Go to this document.
  2. Select the table on the first page and click Home > Copy.
  3. Go into the Displayr document where you want to want the sorted table and press Home > Paste.
  4. Change the data selected for the table.

More advanced table customization

The process for getting Displayr to auto-sort is a bit different to how the rest of Displayr works. It's based on a hack of sorts. Our other product, Q, has various tools for customizing and automatically layout out tables. The two products are compatible, which means that a table created in Q with customizable features can be used in Displayr, and will still work (although there is no way to view or modify its settings once it is in Displayr). Please see Using Q to Customize Tables in Displayr for more information.