On the "Plan Analysis" worksheet, modify the PivotTable to group the data by the values in the "Full Package Price" column. Group the values in steps of 100 beginning at 0 and ending at 200.

PivotTable Numeric Grouping: Explanation Overall Goal The goal is to consolidate individual price values in a PivotTable into meaningful ranges (buckets: $0–$100, $100–$200) so you can analyze data by price tier rather than by every distinct price point. Without grouping, a Pivot

Manage advanced charts and tables

Question

On the "Plan Analysis" worksheet, modify the PivotTable to group the data by the values in the "Full Package Price" column. Group the values in steps of 100 beginning at 0 and ending at 200.

Explanation

PivotTable Numeric Grouping: Explanation

Overall Goal

The goal is to consolidate individual price values in a PivotTable into meaningful ranges (buckets: $0–$100, $100–$200) so you can analyze data by price tier rather than by every distinct price point. Without grouping, a PivotTable on a price column might show dozens of individual values ($85, $92, $110…), making trends impossible to spot. Grouping transforms that noise into structured categories.

Step-by-Step Breakdown

1. Navigate to the "Plan Analysis" worksheet You must be on the correct sheet - PivotTable operations are sheet-specific. Working on the wrong sheet means you'll either not find a PivotTable or modify the wrong one.

2. Click anywhere inside the PivotTable Excel only shows PivotTable-specific ribbon tabs (PivotTable Analyze / Options) when a cell inside the PivotTable is active. Clicking outside gives you no access to grouping tools.

3. Right-click on a value in the "Full Package Price" field (row/column label area) → Select "Group..." You must right-click on the field you want to group - specifically a cell showing a price value in the PivotTable layout, not just any cell. This opens the Grouping dialog for numeric fields.

Alternatively: PivotTable Analyze tab → Group → Group Field

4. In the Grouping dialog, set:

Starting at: 0
Ending at: 200
By: 100
Starting at 0 (not the data minimum): Forces the first bucket to start cleanly at 0, even if no prices exist below some threshold. If you used the auto-detected minimum, your buckets might start at an odd number like $47.
Ending at 200: Caps the range. Values above 200 would appear in an overflow group if they exist.
By 100: Defines the bucket width - each group spans exactly $100 (0–100, 100–200).

5. Click OK Applies the grouping. The PivotTable row/column labels collapse from individual prices into the defined ranges.

What Goes Wrong if Steps Are Skipped

Skipped Step	Consequence
Not clicking inside PivotTable first	Group option is grayed out or missing
Right-clicking a non-price field	Groups the wrong field
Wrong "Starting at" value	Buckets misalign (e.g., $47–$147 instead of $0–$100)
Wrong "By" value	Wrong bucket sizes (e.g., 50-step groups instead of 100)

Memory Tip

Think "Right-click the data you want to bucket → Group → Set your fence posts (start, end, step)."

The three numbers in the dialog are like a ruler: where does it start, where does it end, how long is each tick mark.

Topics

#PivotTable#Data Grouping#Numerical Data#Data Analysis

Community Discussion

No community discussion yet for this question.

Full MO-201 Practice