Where is pivot table tools in Excel 2010?

Where is pivot table tools in Excel 2010?

Click the PivotTable button in the Tables group on the Insert tab. Click the top portion of the button; if you click the arrow, click PivotTable in the drop-down menu. Excel opens the Create PivotTable dialog box and selects all the table data, as indicated by a marquee around the cell range.

How do I sort a pivot table by grand total in Excel 2010?

Sort Largest to Smallest Grand Totals With Excel Pivot Tables

1. STEP 1: Select any cell in the data table.
2. STEP 3: Insert a new Pivot In the Create PivotTable dialog box, select the table range and New Worksheet, and then click OK.
3. STEP 5: Right-click on a Grand Total below at the bottom of the Pivot Table.

How do I show the grand total in a PivotTable?

Click the PivotTable. On the Options tab, in the PivotTable group, click Options. In the PivotTable Options dialog box, on the Totals & Filters tab, do one of the following: To display grand totals, select either Show grand totals for columns or Show grand totals for rows, or both.

How do I get the grand total on top of a PivotTable?

Select a cell in the pivot table, and in the Excel Ribbon, under PivotTable Tools, click the Design tab. Click Report Layout, and select Compact Form or Outline Form. (In Tabular Form, subtotals are only shown at the bottom.) Click Subtotals, and click Show all Subtotals at Top of Group.

Where I can find pivot table tools?

In the worksheet containing a PivotTable, the Ribbon will contain the PivotTable Tools, with ANALYZE and DESIGN Tabs. The ANALYZE tab has several commands that will enable you to explore the data in the PivotTable….PivotTable Options

• Click on the PivotTable.
• Click the ANALYZE tab.
• Click Options in the PivotTable group.

Where are the pivot table tools?

to your
If you’ve selected an Excel table, you’ll see the Table Tools with a Design tab. If you’ve selected a PivotTable, you’ll see the PivotTable Tools with an Analyze and a Design tab. The Table Tools aren’t available on the ribbon in Excel for the web, so you won’t be able to use them to make design changes to your table.

How do I sort the grand total column in a pivot table?

Here’s a quick way to sort data in rows or columns:

1. Click a field in the row or column you want to sort.
2. Click the arrow. on Row Labels or Column Labels, and then click the sort option you want.
3. To sort data in ascending or descending order, click Sort Ascending or Sort Descending.

How do I add a calculated field to a PivotTable?

Add a calculated field

1. Click the PivotTable.
2. On the Analyze tab, in the Calculations group, click Fields, Items, & Sets, and then click Calculated Field.
3. In the Name box, type a name for the field.
4. In the Formula box, enter the formula for the field.
5. Click Add.