Simple Pivot Table Help Needed!

m8j8i8

New Member
Joined
May 4, 2021
Messages
1
Office Version
  1. 365
Platform
  1. MacOS
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!
 

Attachments

  • Screen Shot 2021-05-04 at 5.14.05 PM.png
    Screen Shot 2021-05-04 at 5.14.05 PM.png
    164.1 KB · Views: 4

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Forum statistics

Threads
1,144,676
Messages
5,725,723
Members
422,636
Latest member
GatorsBucs

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top