Create Pivot Tables
  • 12 Mar 2021
  • 1 Minute to read
  • Contributors
  • Dark
    Light
  • PDF

Create Pivot Tables

  • Dark
    Light
  • PDF

Article summary

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

Was this article helpful?

What's Next