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:
You can order table rows and columns in the following ways:
It is possible to keep A-Z order of groups, and order by values only last-level labels with help of "Sort by value only inside group" checkbox ("Format" tab).
You can exclude some rows or columns (or show only concrete rows/columns) with very simple keyword-based "Filter":
>5(if only one measure is used) or
sum>5(to filter by measure name that contains "sum").
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.
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:
Drill-down menu gives you 2 alternatives:
If you like Excel-like drill down by hierarchy with groups expand/collapse this is also possible:
To show values as percentages such as "% of Grand Total" or "% of Row Total" or "% of Column Total":
To show only first top 10 (or top 5, top 100 etc) results in a pivot table:
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).