![]() ![]() The Blank Rows drop-down offers the choice Insert Blank Row After Each Item. Controlling Blank Lines, Grand Totals, and Other SettingsĪdditional settings on the Design tab enable you to toggle various elements. These 27 rows are a summary of the 500+ rows in the original data set, but they also are suitable for exporting to other systems. The result is a solid block of summary data. If you no longer need the original pivot table, select the entire pivot table and press the Delete key to clear the cells from the pivot table and free up the area of memory that was holding the pivot table cache.The report is now a contiguous solid block of data, as shown in Figure 3.14.įigure 3.15 Use Paste Values to create a static version of the data. Rename both fields using the Current Field box on the Analyze tab. Because both fields are numeric, they move to the Values area and appear in the pivot table as new columns. Drop this field between Sector and Customer in the Rows area.Ĭheck Profit and Cost in the top of the PivotTable Fields list. Drag the Region tile from the Columns area in the PivotTable Fields list.Select Design, Subtotals, Do Not Show Subtotals.From the Design tab, select Grand Totals, Off for Rows and Columns. ![]() To make these changes, follow these steps: This would allow you to add Cost and Profit as new columns in the final report.įinally, you want to convert from a live pivot table to static values. And, depending on your future needs, you might want to move the Region field from the Columns area to the Rows area. You don’t need the Grand Total at the bottom. You don’t need the Sectors totals in rows 7, 14, 18, and so on. Say that you want to convert the pivot table shown in Figure 3.13 to be a regular data set that you can sort, filter, chart, or export to another system.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |