![]() Move rows to columns or columns to rows (or "pivoting") to see different summaries of the source data.Expand and collapse levels of data to focus your results, and drill down to details from the summary data for areas of interest to you.Subtotal and aggregate numeric data, summarize data by categories and subcategories, and create custom calculations and formulas.Query large amounts of data in many user-friendly ways.The Design of a PivotTable allows you to: The data given in step 1 above can be summarized and queried in many user friendly ways. To display data for the products under the sea food category select the drop down arrow under row labels and select sea food as below.ħ. Drag the quantity, unit price and product sales fields to the values area as given below.Ħ. Drag the category name and product name fields to the row labels area.ĥ. From the insert tab, in the tables group, select pivot table and click Ok.Ĥ. Refer to the data as given in the example below.ģ. A PivotTable enables you to make informed decisions about critical data in your enterprise.ġ. ![]() Why: A PivotTable report is useful to summarize, analyze, explore, and present summary data. Excel Tips and Tricks / Business Reporting Question: How do I create an interactive report that can quickly be used to summarize large amounts of data?
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |