Audio

We've pushed the pivot table to its limits. But these are the pivot table's limits — not Excel's. There are many ways to go further. With what we have now, let's check whether sales quantity differs between lower-priced and higher-priced items. Using Hot price as the baseline, let's split into two groups: above and below 1,000. The current pivot table is sorted by unit price, so select Panama, Tanzania, India, and Peru from the top — right-click and choose Group. They become "Group 1." Rename