![]() Now your pivot table should display the "Sum of Quantity" and "Sum of Total Cost" fields in their own columns. ![]() If you look at the PivotTable Builder, you will see that currently the Values shows up in the Row Labels box. We want to see these values in multiple columns.Ĭlick somewhere in your pivot table to display the PivotTable Builder. In this example, you can see that the "Sum of Quantity" as well as "Sum of Total Cost" fields are being displayed in one column. How can I set up my pivot table so that the Quantity and Total cost (in the Values section) values show up in two columns instead of being listed in one?Īnswer: Excel may format your Values section of your pivot table to populate all values in one column. The pivot table seems to be populating the Values Section in a single column and I want to see the results in two columns. These fields are the sum of the Quantity as well as the sum of the Total cost of an order. Click the Field List button on the right side of the ribbon. ![]() The tab is called Options in Excel 2010 and earlier. ![]() Click on the Analyze/Options tab in the ribbon. First select any cell inside the pivot table. If you need immediate assistance please contact technical support.We apologize for the inconvenience. The field list can also be toggled on/off from the ribbon menu. Submitting forms on the support site are temporary unavailable for schedule maintenance. Question: In Microsoft Excel 2011 for Mac, I've created a pivot table with two fields in the Values Section of the pivot table. Method 2: Show the Field List from the Ribbon.
0 Comments
Leave a Reply. |