![]() Whenever you create a pivot table, take a few minutes to what happens when you change pivot table layout. This makes a taller, narrower pivot table, so it’s a good layout if you have to print it out in portrait mode. In the screen shot below, I’ve moved Region back to the Values area, and put the Values field in the Rows area, below Category. It can be in the Rows area or the Columns area, but not the Filters area or Values area. Here is the same pivot table with Region in the Rows area, before the Category field.Īnother quick way to change pivot table layout is to move the Values field. To quickly see a different view of the data, you could move the Row or Column fields. Here’s where it appears in the PivotTable Field List. Now the pivot table shows the Quantity for each region, and then the Sales total for each region.īy default, Excel puts that “Values” field in the Columns area of the pivot table, above the other column fields. Excel automatically created the Values field, and its name appears in cell B3. Next, I’ll add the SalesPrice (Sales$) field to the Values area of the pivot table. Only those 3 fields appear in the PivotTable Field List. Quantity (Qty) is in the Values area of the pivot table.To see how the Values field is added automatically, here is the pivot table with only one field in the Values area. There is a free workbook there too, that you can use for testing. Read more about that Values field on my website. It shows the Sigma symbol, just like the AutoCorrect command on the Excel Ribbon. You can also see the Values field in the PivotTable Field List. You can see that field on the worksheet, near the top left of the pivot table. If you have 2 or more fields in the Values area of the pivot table, Excel automatically creates a new field in the layout, called “Values”. Here is a link to the page Multiple Fields in Values Area Written instructions are below the video. See how to create an instant pivot table, then make simple changes to its layout. Watch the video below, and get the free workbook. After you build the pivot table, it’s easy to change pivot table layout, to get a different type of summary. Pivot tables are a quick way to summarize your data, and they have another advantage too.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |