About Applying Formatting from Columns

Applying formatting from columns works best for views when the saved analysis has the same number of columns as the target analysis.

For a single column, formatting is applied to all columns in the tables, pivot tables, and trellises of the target analysis.

For multiple columns, formatting is applied from left to right for column headings and values. If there are fewer columns in the saved analysis than in the target analysis, the format of the last column in the saved analysis is repeated in the subsequent columns of the target.

For example, suppose the saved analysis contains four columns in the following color order: red, green, blue, yellow. When applied to the six columns in the target analysis, the color order would be: red, green, blue, yellow, yellow, yellow.