Add a pivot table with a category classification

From a worksheet with lines you add a pivot table with a category classification.

To add the pivot table:

  1. Open the analysis:.
  2. Add a pivot table.

    Only select the 'Extend bottom of data area with adjoining fixed data' check box if you have manually added lines to the worksheet on which the pivot table is based.

  3. Click on: OK.
  4. Drag the fields from Profit to the correct box. For example, drag the category classification to the 'Row Labels' box.
  5. Continue to configure the pivot table.

    Draaitabel toevoegen met categorie-indeling - Setup

    You now have a formatted pivot table.

    Draaitabel toevoegen met categorie-indeling - View2.png

Directly to

  1. Use categories in an analysis
  2. Add a category classification
  3. Apply a category classification to a column
  4. Add a pivot table with a category classification