Logo Of Smart Pivot table generator

Row settings

Rows settings of Smart Pivot table generator

In this section you need to define what should appear in the "Row labels" area – these are the row 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 row headers
  • Other names you might want to give to your columns instead of their original SQL names (Not required)

This option enables you to split your pivot table into several pages and easily navigate between them. Pagination shouldn't be used unless you have a really huge number of columns or rows.