Logo of Smart Pivot table generator

Column Labels

Generated pivot table

In this section you need to define what should appear in the "Column labels" area – these are the headers of the pivot table. You need to specify:

  • The name of the database table and column that stores the data you want to list in the headers
  • If the selected columns store date values, you will have the option to select to display the month or the year from those date values. If no option is selected, the complete date should appear in the pivot table.
  • The columns of the table are dynamic. These dynamic columns are converted from certain rows from one of your MySQL database tables.

Smart Pivot table Columns Settings