First, click on a cell in one column, to select it.In this example, I’ll select a cell in each of the following fields – AvgCost, SubTotal and Discount ![]() To remove three of the Value Fields, I’ll start by selecting at least one cell in each field that I want to remove. Click on the link to download sample file 4 – Remove Value Fields.Scroll down to the Get the Sample Files section.Or, on the same page, download the sample Excel workbook, which has the macro in it Copy the code from the web page, and paste it into a regular code module in your workbook.You can get the macro code from the Pivot Table Field Layout Changes page on my Contextures site: To remove the selected Value fields, I’ll use a macro named PivotRemoveValuesSel PivotTable Field List Get the Macro to Remove Selected Value Fields Sometimes you can only see 2 or 3 fields at a time, and you waste time scrolling up and down, looking for a specific field. That way, I won’t have to scroll through the list of fields in the PivotTable Field List, looking for each field, to uncheck it. I could remove the Value fields manually, one at a time, but I’ll use a macro to make this job easier. pivot table which has 5 fields in the Values area Fields in PivotTable Field List To create a smaller report, I’d like to remove 3 of those value fields, and just leave Qty and Price. In the screen shot shown below, there’s a pivot table which has 5 fields in the Values area Just select one or more fields, and run the macro! In large pivot tables, with lots of fields, this macro makes it easy to remove specific fields from the Values area. ![]() To add or remove fields from the layout, you can check or uncheck fields in the PivotTable Field list. Pivot tables make it easy to work with your data, and see the summaries in different layouts.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |