Skip to main content
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY
cancel
Showing results for 
Search instead for 
Did you mean: 
vanderson009
Creator III

Difference between Straight and Pivot Table

Hello Community,

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

-- Thanks In advance.

Villyee Anderson.

1 Solution

Accepted Solutions
VishalWaghole
Specialist II

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

View solution in original post

2 Replies
VishalWaghole
Specialist II

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
Luminary Alumni

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