The data is grouped with three levels and the subtotals are calculated location wise. Select Unit and Amount under Add subtotal to:Ĭlick OK. The data gets selected and the Subtotal dialog box appears. The data is sorted location wise.Ĭlick Subtotal in the Outline group. You can obtain the sum of sales location wise using Subtotal.ĭata is selected. To understand how to use Subtotal and Outline, consider the following example wherein the sales data of various items is given salesperson wise and location wise. Each inner level displays detailed data for the preceding outer level. Outer Levels are represented by Lower Numbers and Inner Levels by Higher Numbers. You can create an Outline of up to eight levels, one for each group. Note that Subtotal and Outline can be used only on a range and not on a table. You can use PivotTable also for this purpose, but using Subtotal and Outline is the quickest way to analyze a range of data. If you have a list of data that you want to group and summarize, you can use Excel Subtotal and Outline to display summary rows or columns.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |