2 Replies Latest reply: Apr 17, 2015 2:45 PM by Jonathan Poole RSS

    what is difference between straighttable and pivottable

      what is difference between straight-table and pivot-table

        • Re: what is difference between straighttable and pivottable
          Manish Kachhia

          Stright Table vs 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.

          • Re: what is difference between straighttable and pivottable
            Jonathan Poole

            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.