Adding additional column of data to pivot table

  • Thread starter Thread starter eggman2001
  • Start date Start date
E

eggman2001

I have a data table that has 7000 rows, which I'm slicing using a
pivot table. Column A has 150 unique values. I'd like to add another
pivot table field (let's call it field F), which will have three
unique values. I will decide which of the Column A values should match
up to three field F values.

Obviously, I don't want to do this for 7000 rows but just for the 150
unique Column A rows. Can someone tell me what the best way is to do
this?

In database theory, I guess what I want is to create another table and
then join them, but I'm not sure if that is common in Excel.
 
Hi
On another sheet in column A list your 150 unique values and in column B
enter the 3 values you want each of those 150 allocated.
In your main data table
=VLOOKUP(A2,Sheet2!A:B,2,0)

Copy the column>Paste Special>Values

Alternatively, you could use Grouping within the PT.
Having created the PT, with your 150 unique items as row items, hold down
the control key as you select each of the items you want to belong to new
Group 1>right click>Group and Show Detail>Group>Change name Group1 to
whatever you want.
Repeat process for the other 2 new groups you want to add.
 
Back
Top