This documentation page assumes that you already have a SeekTable account. You can create free account by signing up.

Create Pivot Table

Pivot Table allows you to summarize and analyze data in terms of groups; with pivot tables you can see comparisons, explore trends and get answers on questions like "what is happened" and "why".

With SeekTable you can create pivot tables in seconds:

  1. Connect to your data: upload a CSV file or setup database connection.
  2. Add new report: click on "Create Report" from cube, or choose "+" next to cube's name in the left menu.
  3. Keep "Report Type" option at "Pivot table"
  4. Choose grouping criteria: what columns to use for "Rows" and/or "Columns".
  5. Choose a measure to display as value in the table: this may be count of rows, sum or average of some column. Pivot table will calculate these values for each cell in the table. You can choose several measures at once.
  6. Click on "Apply"
Pivot table configuration form Pivot table example

Sort Pivot Table

You can order table rows and columns in the following ways:

Filter pivot table

You can exclude some rows or columns (or show only concrete rows/columns) with very simple keyword-based "Filter":

Pivot table filter

One more way to filter report data is usage of report parameters. This kind of filter is applied on the row level; in case of database filtering condition is included into the query. This means that with report parameters it is possible to filter even by columns that are not used in the report.

Params tab appears when at least one report parameter is configured for the cube.

Drill Down

SeekTable offers great data exploration capabilities with drill-down function: you can click on any pivot table cell with value and get more detailed view for this concrete group:

Pivot table drill-down on click by value

At drill-down menu you have 2 alternatives:

Pivot table drill-down by dimension

If you like Excel-like drill down by hierarchy with groups expand/collapse this is also possible:

Pivot table groups expand/collapse