![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() The default tables produced may not display information as neatly as you would like, or the information may not clearly make your point. With pivot tables, you can transpose rows and columns ("flip" the table), adjust the order of data in a table, and modify the table in many other ways. For example, you can change a short, wide table into a long, thin one by transposing rows and columns. Changing the layout of the table does not affect the results. Instead, it's a way to display your information in a more intuitive manner.
Pivot
Pivoting Trays provide a way to move data between columns, rows, and layers.
The order of the pivot icons in a dimension reflects the order of the elements in the table.
|
|
Pivoting a Table |