Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
its_anandrjs

Difference between Pivot Table $ Straight Table

Hi,

What are the Basic and Main differences between Pivot Table $ Straight Table. Please provide info about that.

Anand

Regards

5 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     What i have found until now is.

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

     In a povit table you can not drag expression in middle of expression, but you can do that in straight table.

     Hope this will help you.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
avinashelite

this are the difference which I have observed

Straight Table

* Has Dimension limits

*Repetitive data representation

*We can hide the dimension and expression easily

*no sub total options

*No Pivoting

*Better performance

PivotTable

* Has no Dimension limits

*Tabular format  data representation

*We cannot  hide the dimension and expression easily

*sub total options

*No Pivoting

* Less performance compared to straight table

etc

Anil_Babu_Samineni

Avinash, How many dimensions we can use in Straight Table?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
avinashelite

As per I know their is no limitations on the number of dimensions in straight table as the number of dimension increase it might take more time to generate the chart