Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
What is the differenct between pivot table and straight table ?
Thanks
Vikas
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.
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.
HIC
Thanks for better understanding....