---
title: "Create Pivot Tables"
slug: "create-pivot-tables"
updated: 2021-03-12T00:14:17Z
published: 2021-03-12T00:14:17Z
canonical: "onpremises.webtrends.help/create-pivot-tables"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://onpremises.webtrends.help/llms.txt
> Use this file to discover all available pages before exploring further.

# Create Pivot Tables

Use pivot tables to view multi-dimensional data. In Webtrends, the simplest report is multi-dimensional, because time is a dimension.

Pivot tables are an easy way to increase insights into data through aggregation (sums, averages, etc.). You can easily “pivot” the data to exclude a dimension, reorder measures, and so on.

1. Open a workbook with Webtrends data imported into a table.
2. Highlight a cell in the table and select Insert > PivotTable. The Create Pivot Table dialog box appears.
3. Select New Worksheet and click OK.
4. Drag dimensions to the Row Labels area and measures to the Values area to create a data structure similar to a Webtrends report. You can also:

- Expand and collapse rows
- Re-sort by selected measures, or limit the view to only the measures of interest
- Remove the time dimension to aggregate like values across time periods
- Remove the Entry Page dimension to get an aggregate of all referring sites
- Use the filter to filter out entry pages with less than a given number of visits