Then, select two ranges, and enter the same name, such as H1 and H2, in the Field two box. If you selected 2 under How many page fields do you want?, do the same as the previous example in the Field one box. ![]() If you have four ranges and each one corresponds to a different quarter of the fiscal year, select the first range, enter Q1, select the second range, enter Q2, and repeat the process for Q3 and Q4. ![]() If you selected 1 under How many page fields do you want?, select each range, and then enter a different name in the Field One box. Under What item labels do you want each page field to use to identify the selected data range?, for each page field, select the cell range, and then enter a name for that range. Under How many page fields do you want?, click the number of page fields that you want to use. Tip: If the cell range is in another workbook, open the workbook first to make it easier to make select the data. To create a consolidation that uses multiple page fields, do the following: This lets you create partial or full consolidations for example, one page field that consolidates Marketing and Sales apart from Manufacturing, and another page field that consolidates all three departments. You can create multiple page fields and assign your own item names for each source range. Go back to the workbook and select the cell range, and then back on the PivotTable and PivotChart Wizard, click Add. On Step 2b page of the wizard, do the following: On Step 2a page of the wizard, click I will create the page fields, and then click Next. On Step 1 page of the wizard, click Multiple consolidation ranges, and then click Next. In the list, select PivotTable and PivotChart Wizard, click Add, and then click OK.Ĭlick a blank cell (that is not part of a PivotTable) in the workbook.Ĭlick on the PivotTable Table and PivotChard wizard icon on the Quick Access Toolbar. Under Choose commands from, select All Commands. ![]() To do that:Ĭlick the arrow next to the toolbar and then click More Commands.Ĭlick Customize Quick Access Toolbar ( …) in the bottom left-hand corner below the ribbon and then click More Commands. To combine the data from all the ranges and create a consolidation that does not have page fields, do the following:Īdd the PivotTable and PivotChart Wizard to the Quick Access Toolbar.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |