How to Sort Single Column Summary Tables Using R

Introduction

This article describes how to go from an unsorted table...

..to a table that is sorted.

1. Select your table.

2. Copy the name from Properties > GENERAL > Name.

3. Select Calculation > Custom Code.

4. Go to Properties > R CODE in the object inspector.

5. Add a line to the code that defines the table as table = table_name where table_name is copied from step 2.

6. Add this line to the code to sort in descending order: table[order(table, decreasing = TRUE)]

Below is the code from this example that sorts in decreasing order:

table = table.Preferred.cola
table = table[order(table, decreasing = TRUE)]