Difference between Straight and Pivot Table

[vanderson009]

Hello Community,

Could any one please share the points about difference between Straight and Pivot Table.?

-- Thanks In advance.

Villyee Anderson.

[VishalWaghole · Accepted solution]

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,

Vishal Waghole

[jvitantonio]

Hello V,

In pivot table as it names says,     you can move columns vertical and horizontally. You also have drill down and up capabilities.

A straight table is a plain table. You are not able to drill. However, you will see a "Dimensions Limit" tab that is very useful when you want to show, for example, top 10 results.

There's a lot of information in the forum, but I would recommend you play with both tables a bit.

Best

JV