Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
what is difference between straight-table and pivot-table
Also, below I got from an old post given by JAGAN MOHAN
Straight Table:
You have to write one or more expressions.
Grouping is not possible.
Sub totals is not possible.
Expression Total and Sum of rows mode is available for expression.
Better performance.
Pivoting of dimension is not possible.
COLAPSE/EXPAND column is not possible.
Pivot Table:
You have to write one or more expressions.
Grouping is possible.
Sub totals is possible.
Expression Total mode is available for expression.
Poor performance when compared to Straight table.
Pivoting of dimension is possible.
COLAPSE/EXPAND column is possible.
Both display an aggregated set of data in tabular format. Both are text based but straight tables can also display mini charts .
The pivot table has row headers and column headers as well as nested headers on both. Nested header can be expanded/collapsed via +/- button. The headers and nested headers are populated by chart dimensions . The cells that define the intersection of the row and column header is defined by the chart expression.
The straight table only has column headers. No nesting and no row headers. They are like a CSV file (rows of data) but each row is an aggregation.
There are other differences in capabilities but thats the guts of it.