hi

[#1]

differences between straight table and pivot table

[Miguel_Angel_Baeyens]

Hello Satya,

Welcome to the forums! Can you please edit the title of your post to reference to your question and elaborate a bit more about what do you need help?

Miguel

[ashfaq_haseeb]

Hi,

Check this

Re: Pivot Table vs Straight Table (Performance)

Hope it helps

Regards

ASHFAQ

[nagarjuna_kotha]

Pivot Table	The pivot table presents dimensions and expressions in table form. There is no formal limit to the number of dimensions or expressions possible. A pivot table can be defined without expressions, generating a tree view for navigating the dimension levels.
Straight Table	The straight table differs from the pivot table in that it can not display subtotals and that the grouping of dimensions is shown in record form so that each row of the table contains field and expression values.

Regards,

Nagarjuna

[Anonymous]

Hi,

Following are differences in

Straight Table	Pivot Table	Table box
Subtotals is not possible in Straight table.	In a pivot table, expressions can be "rolled up" with subtotals (using the Show Partial Sums setting).	No expressions available.  SoSub Totals is not possible.
Interactive sorting of Dimensions is possible.	Interactive sorting of Dimensions is not possible.	Interactive sorting is possible.
It is not possible to drilldown to a deeper level, duplicate values are displayed.	It is possible to drilldown (grouping) to a deeper level by clicking on expand icons.	Drilldown  is not possible.
Pivoting is not possible.	A cross-table (pivoting) is possible by dragging dimensions to the top of the header row.	Pivoting is not possible
It is possible to set any of the Total modes like Expression Total and Sum of Rows.	It is not possible to set the Total Mode, by default it uses the Expression Total.	Totalling is not available.
Dimension Limits tab is available for this.	Dimension Limits is not available.	Not available.
Accumulation of values is possible.	Accumulation of values is not possible directly, you have to write separate expressions.	Accumulation of values is not possible.

Hope this helps you.

Regards,
Alex