How to Index Data in a PivotTable

MORE INFORMATION

1. Create a new worksheet, and enter the following values:

          A1: Fruit       B1: State   C1: Sales
          A2: Bananas     B2: CA      C2: $800,107
          A3: Pears       B3: TX      C3: $547,236
          A4: Kiwi        B4: CA      C4: $669,076
          A5: Apples      B5: CA      C5: $622,236
          A6: Cherries    B6: CA      C6: $656,097
          A7: Pears       B7: CA      C7: $674,218
          A8: Cherries    B8: PA      C8: $697,711
          A9: Kiwi        B9: CA      C9: $550,637
         A10: Bananas    B10: PA     C10: $602,124
         A11: Apples     B11: PA     C11: $669,916
         A12: Kiwi       B12: PA     C12: $693,306
         A13: Apples     B13: TX     C13: $589,278
         A14: Pears      B14: PA     C14: $739,241
         A15: Cherries   B15: TX     C15: $682,213
         A16: Bananas    B16: TX     C16: $791,944

2. On the View menu, click Toolbars. In Microsoft Excel 97 or Microsoft Excel 98 Macintosh Edition, click PivotTable. In Microsoft Excel 5.0 or 7.0, click to select the Query And Pivot box, and then click OK.
   
   This step causes the Query and Pivot or PivotTable toolbar to appear.
3. To create the % of Total PivotTable, select any cell within the data in step 1 and click the PivotTable button (the first button) on the Query And Pivot Toolbar.
4. In the PivotTable Wizard, select "Microsoft Excel List or Database", and then click Next.
5. Under Range, confirm the range to be $A$1:$C$16, and then click Next.
6. Drag the button labeled Fruit to the box labeled ROW. Drag the button labeled State to the box labeled COLUMN, and drag the button labeled Sales to the box labeled DATA.
7. In the Data Field, double-click Sum Of Sales.
8. In the Pivot Table Field dialog box, click Options. Under Show Data As, click "% of Total," and then click OK.
9. Click Next.
10. In Microsoft Excel 97 or Microsoft Excel 98 Macintosh Edition, click the Existing worksheet button, click in worksheet cell E1, and then click Finish.
    
    In Excel 5.0 or 7.0, with the pointer in PivotTable Starting Cell, click in worksheet cell E1, and then click Finish.
    
    This step creates the first PivotTable in cells E1 to I8.
11. To create the Index PivotTable, repeat steps 3 through 7.
12. Click Options and click Index under Show Data As. Click OK in the Pivot Table Field dialog box.
13. Click Next.
14. In Microsoft Excel 97 or Microsoft Excel 98 Macintosh Edition, click Existing Worksheet, click in worksheet cell E10, and then click Finish.
    
    In Microsoft Excel 5.0 or 7.0, with the pointer in PivotTable Starting Cell, click in worksheet cell E10, and then click Finish.
    
    This step creates the second PivotTable in cells E10 to I17.

Analysis of the Results