![]() Now your pivot table should display the "Sum of Quantity" and "Sum of Total Cost" fields in a single column, populating down. If you look at the PivotTable Builder, you will see that currently the Values shows up in the Column Labels box. ![]() We want to see these values in a single column.Ĭ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 multiple columns. How can I set up my pivot table so that the Quantity and Total cost (in the Values section) values show up in a single column instead of being listed in two?Īnswer: Excel may format your Values section of your pivot table to populate your values in multiple columns. The pivot table seems to be populating the Values section in multiple columns and I want to see the results in a single column. ![]() It’s a process where you visually group the column items or datasets for a better display. Shift+Alt+Left Arrow is the shortcut key to ungroup columns or rows. These fields are the sum of the Quantity as well as the sum of the Total cost of an order. Shift+Alt+Right Arrow is the shortcut key to group columns or rows, whereas. Question: In Microsoft Excel 2011 for Mac, I've created a pivot table with two fields in the Values Section of the pivot table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |