> For the complete documentation index, see [llms.txt](https://docs.mashmatrix.com/mashmatrix-sheet/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.mashmatrix.com/mashmatrix-sheet/functions_advanced/time_series_matrix_transformation/add_matrix_column.md).

# Add Matrix Column

To display time-series matrix-transformed data in a sheet, a type of column called a "matrix column" should be added to the sheet. To add a matrix column, follow the steps below.

![](/files/8TQrzxhTQVTBapTmo2e6)

1. Select "Add Columns" from column header menu.
2. Click "Time-series Matrix Column" tab in the column setting dialog.
3. **\[A] Child Relation Object** - Select a related list which you want to apply time-series matrix transformation.
   * Only related lists placed in the default page layout of the object will be listed in the "Child Relation Object" pulldown.
4. **\[B] Series Field** - Select a field that will be the axis of time-series matrix transformation.
   * Currently only date type fields can be selected as Series Field.
5. **\[C] Interval** - Specify the display interval of time series field. Choose from the following values:
   * Yearly
   * Quarterly
   * Monthly
   * Weekly
   * Daily
6. **\[D] Start** - Specify the start date of time series value.
7. **\[E] Duration** - Specify the duration of the time series in number, which must be an integer greater than or equal to 1.
8. **\[F] Column Field** - Select fields from related list object which will be displayed inside of matrix column. If you click **\[G] Add Column Field** link, you can add multiple fields at once.