Re: what is difference between straighttable and pivottable
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.