This documentation page assumes that you already have a SeekTable account. Create your free account by signing up.

How to create a Pivot Table

Pivot Tables (also known as "crosstabs") allow 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".

In SeekTable you can easily create pivot tables:

  1. Connect to your data: upload a CSV file or a 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".
    Hold CTRL to select multiple items at once.
  5. Choose a measure (aggregate function) to display in the pivot table: this may be count of rows, sum or average of the column. SeekTable will calculate aggregates for each row x column intersection. 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 a 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

Drill-down menu gives you 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

Pivot Table Percentage

To show values as percentages such as "% of Grand Total" or "% of Row Total" or "% of Column Total":

  1. open Format tab
  2. in the Value Calculations dropdown choose an appropriate option:

Pivot table percentage of total

Pivot Table Top 10 show only top N rows and/or columns

To show only first top 10 (or top 5, top 100 etc) results in a pivot table:

  1. open Format tab
  2. use appropriate Limits dropdown to apply a top-N filter for either rows or columns or both:

Pivot table top 10

All results that are beyond the limit are included into special "..." group. To hide this group you can uncheck Show "..." group in case of limit .

Note that by default exports include only data that you see in the web view. If you want to export all rows/columns you may check Export all data option, and in this case export will include as much rows as possible (up to 50,000 on cloud SeekTable; this limit can be increased on self-hosted SeekTable).