Creation of straight and pivot tables

[Anonymous]

when we use pivot and straight tables?

[oknotsen]

To show the numbers in stead of visualizing them.

[mightyqlikers · Accepted solution]

hi pavan,

for example if you want to display region wise month on month sales then better to go for Pivot table

like take region and month as dimension and sum(sales) as expression

then drag the moth over expression it will display as pivot.

Straight table : if you want to dispaly aggregated data then better go for Straight table.

$@M

[settu_periasamy]

see What is difference between pivot table and straight table also

[HirisH_V7]

HI,

Pivot table-

1) A pivot table is better at grouping: you can easily see which group a specific row belongs to, and a group can have a subtotal.

2) You can also display a pivot table like a cross table (one or several horizontal dimensions).

3) But when you sort a pivot table, you have to sort it first according to the first dimension, then according to the next, etc.

    You cannot sort it any way you want.

Straight table-

A straight table is better at sorting than a pivot table: you can sort it according to any column.

But it is not so good at grouping. Subtotals are not possible, for instance.

HTH,

-Hirish

[abirami_palanis]

Hi,

Pivot:

    Pivot table shows dimensions and expressions in rows and columns , for example in cross table. We can use pivot table for Group Analysis and Hierarchy based analysis.

    Here columns are always sorted based on first dimension.

Straight:

It is like normal table table structure but we can perform Aggregation.

The grouping of dimension is shown in record form.

In opposition to the pivot table, the straight table cannot display sub totals or serve as a cross table.

[Anonymous]

Hi Pavan,

Below are the points which can explain in which scenarios we should be using straight table and pivot table.

Straight Table:

• Straight Tables allow interactive sorting. User can sort according to the requirement.
• Dimension limit is present. This feature can be used to limit the dimensions and view the result as desired.
• Columns can be hidden in straight table. Only the desired columns can be shown, rest all can be hidden.

Pivot Table:

• Sorting is fixed by sort property only. customized sort cannot be done.
• Dimensions can be displayed on both rows and columns.
• Pivot tables are better at grouping. Partial sums can be displayed.
• Cross tables can be created by dragging dimensions.
  

[#8]

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,

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.

It used to be the case that straight tables only had a grand total, whereas pivot tables could have sub-totals by using the partial sum option.

There is no dimension limits tab in Pivot Tables

[#9]

Difference between straight table and pivot table