Stright Table vs Pivot Table

[NavinReddy]

Hi All,

Plz Explian me i want know about one thing ,What The use of Stright Table and pivot Table

When we are go with string table and pivot table

Tell me one secnario when we r using pivot table and when we r using stright table

Thanks in Advance

Niranjan

[#2]

Straight table is a simple display of all the data present in the table.

But Pivot table is something where we use aggregations and summations to display the data that makes more sense.

Straight table is something like : select * from table;

whereas pivot table is something like : select a, b, sum(c), avg (d) from table group by a,b ;

Another difference is you cannot eliminate duplicate rows from Straight table.

[neha_shirsath · Accepted solution]

Hi Niranjan,

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.

Regards,

Neha

[NavinReddy]

Hi

Thanks to All really its helpfull for me

Thanks & Regards

Niranjan

[er_mohit]

Hiii

In pivot table you can drag the dimensions over the expression. Means Dimension shown as column. This is not possible in Straight table.

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. You can also display a pivot table like a cross table (one or several horizontal dimensions). 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.

  In a povit table you can not drag expression in middle of expression, but you can do that in 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.

[NavinReddy]

Hi Mohit,

Thanks a lot its really its was nice answer

Thanks & Regards

Niranjan

[#7]

- In Pivot table multiple measure can be used where as in straight table only single measure can be used.

- In Pivote a cross table can be created by dragging dimensions but same thing is not possible in straight table

- A straight table is better at sorting then 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.

[#8]

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.

Not exactly true. If you go to the "Sort" tab, and select "expression", you can sort any dimension according to an expression that you have created (which is not necessarily shown in the pivot table). For example, if you have a pivot table that has "Sales Rep" as the first dimension, "Customer" as the next and "Sale Month" as the third dimension (which you pivot against to make it a horizontal dimension) and sum(Sales) as your expression, the table will rank Sales Reps alphabetically, then Customer names within the rep, and by Sale Month. But if you override the Sales Reps sort, and put sum(Sales) as the expression and choose "descending", it will show the salesperson with the top sales for the forecast period first, then the next ranked, etc.

So you can, sometimes, achieve the sort you want.