Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can any one explain the difference between straight ,pivot and table box
Read here:
Difference between straight table and pivot table
Also read the Reference Manual.
To give you a brief idea
Straight table: Displays data one row per dimension with > 1 expressions. You have dimension limits tab to show top and bottom rows based on high and low ranks.
Pivot table: Groups the data on no. of dimensions used with >1 expressions. You can move your dimensions to show as column values as rows and rows columns. No dimensions limits in this you have to use rank() and Aggr() to show top and bottom values.
Table box: It is just a table with columns and rows not expressions can be added. This is just used to display data as is.
Thanks for response and it is very helpful.