Manually Grouping Text in a PivotTable

Grouping data in a PivotTable can help you show a subset of data to analyze. In my example, I took GA, NC, and SC and grouped them and named them South. I took CA, WA, and OR and grouped them and named them West.

Pin It on Pinterest