Simple Pivot Table Help Needed!

[m8j8i8]

Hi,

I'm fairly new to excel and I'm looking for a way to create a pivot table that does the following: There are 3 companies, and each company has 3 categories. Each of those categories has a number of impressions associated with it. I want to make a pivot table that sums categories 1 and 2 impressions as a single entity and then has category 3 as a separate one. I plan to use this on a much larger scale but wasn't sure the formula/setup to get this.

Attached is a visual example of what I want with everything built manually. Any help would be appreciated

Thanks!

 

[arthurbr]

Hi
you can group elements as required with a Pivot Table How to Group Excel Pivot Table Data