The first question to ask is, "What am I seeking?" In the example here, let us ask, "How many Units did we sell in each Region for every Ship Date?":Ī pivot table usually consists of row, column and data (or fact) fields. The usage of a pivot table is extremely broad and depends on the situation. A pivot table can help quickly summarize the data and highlight the desired information. While tables such as these can contain many data items, it can be difficult to get summarized information from them. Mechanics įor typical data entry and storage, data usually appear in flat tables, meaning that they consist of only columns and rows, as in the following portion of a sample spreadsheet showing data on shirt types: In 2007 Oracle Corporation made PIVOT and UNPIVOT operators available in Oracle Database 11g. Excel 2000 introduced "Pivot Charts" to represent pivot-table data graphically.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |