How to Abbreviate Month Labels in Tables

This article describes how to go from a crosstab with a Date variable...

...to a table with abbreviated month labels:

Requirements

• A crosstab with a Date/Time variable in either the rows or columns which has been aggregated to monthly

Method

1. Select your table.
2. In the toolbar go to Automate > Browse Online Library > Modify Headers > Abbreviate Month Labels.
3. Set the Months in field to columns or rows (based on where your dates are in the table).
4. Press OK.

Note, if you select Swap rows and columns on your table, the rule will no longer work due to the table dimensions changing. In this case, you will have to right-click your rule in the Rules tab > Edit Rule and change the Months in parameter accordingly.

Next

How to Use Rules in Q