Fixed Columns

Fixed columns, when they exist in a table, are always visible and are separated from the other columns by a vertical orange line.

Fixed columns do not scroll off the page, regardless of how far the table is scrolled in either direction. This is useful when a column has key information about each row that the user would always like to see.

In the following example, the State and Month columns are fixed columns. You can see the vertical orange line separating them from the other columns.

Fixed columns will remain visible even if you scroll all the way to the right, to the last column of the table, as shown in the following example:

Tables do not necessarily need to be loaded with fixed columns. However, you can imagine that in some tables it would be useful from an end user's perspective.

Once a table is opened, a user can actually modify which columns are fixed through one of two methods:

Tabulations

After a tabulation, the "group by" (aka <breaks>) columns are automatically fixed.

For example, let's do a tabulation on the Monthly Statewide Non-Seasonally Adjusted Unemployment Statistics table. If we group by state and take the average of the unemployment rate for each state, the resultant table will be displayed as follows:

Note that the State column appears as a fixed column (to the left of the vertical orange line) because we grouped by that column in our tabulation.

Macro Language

The fixed attribute of the <col> element in the Macro Language can be used to fix (or unfix) columns.

The following Macro Language code will add the Unemployed column to the fixed columns:
<col name="unemp" fixed="1"/>

Because the Unemployed column is now a fixed column, it appears to the left of the vertical orange line, with all the other non-fixed columns to its right.

If you wanted to unfix a column, you would set the fixed attribute to 0:

<col name="month" fixed="0"/>

Notice how the Month column is now positioned to the right of the vertical orange line, signifying that it is not a fixed column any longer.