0
There are different things you can do. Fields can be dragged if you open the field list settings. You can also add and remove fields. You can specify which fields you want as row, column and data elements. You can start a pivot table from the beginning and re-arrange what way you want to see the fields. It will also depend on the version of Excel you have as there are improvements in the more recent versions.
Wiki User
∙ 10y ago
Wiki User
∙ 7y agoTo add fields to a pivot table in Excel, you can select the initial data, and when you have a list of fields, you can drag them into place.
Add your answer:
Earn +20 pts
How can you sort by two values on a pivot table on excel 2010 e.g. Sorting by points and then goal difference in a football league table?
If you double click on the last columns header you can open the pivot table window. Then click on Advanced then in the new window and select the Autosort option using the fields you need. You can do a league table in an ordinary table in Excel, not a pivot table. You can use an advanced sort and use the fields you want to do your sort on, choosing them in the sequence you mentioned. That may be easier.
What is a powerful tool for summarizing in a table in Excel?
A pivot table.A pivot table.A pivot table.A pivot table.A pivot table.A pivot table.A pivot table.A pivot table.A pivot table.A pivot table.A pivot table.
What are the areas of a pivot table report where fields can be placed?
They can be put into Filters, Rows, Columns and Values. Only numerical fields can be put into the Values area.
Which group on the fields tab contains the options you use to add new fields to a table?
add new field
Can A Pivot Table be sorted and filtered?
Yes, you can both sort and filter a pivot table.
What is the short cut key for pivot table in MS Excel?
There are many shortcut keys associated with Pivot tables. These are after the table has been created. There is not a standard key to create a Pivot table. You would normally use the Pivot table wizard.
How do you get text in a pivot table?
If you select the main text headings, they will be included in the pivot table as headings. You can type into any cell in a pivot table that has text, though not ones that have values.
What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changed?
format riport
To make changes to Pivot table data you must do what?
You would change the source data and refresh the pivot table.
Where can one buy a pivot table?
A pivot table is a tool used in data analysis to look at variable data. The easiest way to create a pivot table is to use the pre-made template on Microsoft Excel.
How are fields such as region state and country most likely to appear in a pivot table?
They will appear as row or column headings. The way you want them is entirely up to you and based on your requirements. Given the nature of pivot tables, they can be moved to give different information.
What cannot exist in Excel without an associated Pivot Table?
A pivot chart.A pivot chart.A pivot chart.A pivot chart.A pivot chart.A pivot chart.A pivot chart.A pivot chart.A pivot chart.A pivot chart.A pivot chart.
