This seems rudimentary but...

I'm attempting to analyze data in a pivot table.  I have three columns: the first being the main category and the second two being subcategories of the first.  The further columns to the right are co...