combining data in a pivot

yellowcabguy

Active Member
Joined
Dec 28, 2005
Messages
440
Is there a way in a pivot table to combine columns of data into a new column. In the example below can I combine "cats" and "cat-Kitten" into a new column called CATS witha total of 22. Same issue for dogs.


Cat Cat-Kitten Dog Dog-Puppy
16 6 149 10
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
Here is a way I can think of straight away:
use Grouping to group "cats" and "cat-Kitten" and to group "Dog" and "Dog-Puppy". You can name the new groups as you like. Then remove the original field ( the new groupings should generate a new field level ).
 

GorD

Well-known Member
Joined
Jan 17, 2004
Messages
1,446
Works for me, example below.
Book1
ABCDE
1TypeQty
2Cat1
3Cat2Sum of Qty
4Kitten3Type2Total
5Dog4Cats23
6Puppy5Dogs22
7Dog6Grand Total45
8Puppy7
9Cat8
10Kitten9
Sheet1


Select the items to group prior to grouping. Use ctrl key if they are non-consecutive
 

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
Hi yellowcabguy, what did you try to do exactly ( please give all the steps you tried )?
 

Forum statistics

Threads
1,136,267
Messages
5,674,729
Members
419,523
Latest member
Urnovio

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