0
Filtering reduces the amount of records you can see, by picking ones that meet certain criteria. Pivot tables are for getting totals for categories. So if you had a list of data for different regions, you could just show the list of one region using filtering, whereas with a pivot table you could show different kinds of totals based on the different regions. They could include counts, averages, a max or min for each category, and many other things. A pivot table can do far more things and is a very powerful tool, so there are many other differences.
Wiki User
∙ 8y ago
Add your answer:
Earn +20 pts
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.
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.
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.
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.
What is the difference between a pool table light and a billiards table light?
There is no difference.
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.
What is difference between pivot tables and vlookup?
They are used for very different things. Pivot tables are used for summarising data and grouping things together to present them in a table. For example, given a list of individual sales for various salesmen in different regions, a pivot table could give totals per salesman and totals per region or averages or maximums or minimums etc. A vlookup is for searching data for a match and returning a value from a table. the data is arranged in a table, with the first column being the one that is searched with a value then being returned from a specific column on that row.
What is the difference between master table and transaction table?
chut
