MGMT

Here's an easy? step-by-step recipe:

1) Select all the data on tab Pivot Table Data.

2) Click button Pivot Table on tab Insert

Did you find that button?

3) The Create PivotTable window pops up.

4) Click OK to select the defaults

5) PivotTable Fields pane opens on your spreadsheet. In PivotTable Fields, see the unchecked boxes for Movie Rank, Domestic Gross, Rating, and Type.

6) Click and drag Type to areas Rows and to Σ Values

7) Click and drag Domestic Gross to Σ Values

The finished table looks like