Pivot table add one column

D

Daniel

How can I add one column in pivot table? When I added a column of Average 100,
pivot table created 3 more columns for the first 3 columns( and I don't like
it)


My data

Book Label Price Average
A Hard paper 200 100
B Soft 100 100
C Hard paper 200 100
F Plastic 50 100
K Soft 100 100
L Plastic 50 100
M Hard paper 200 100
K soft 100 100
R Soft 100 100
T Plastic 50 100


-------------------------------------------------------------------------------------------
My pivot table is below


Data Label
Average of Price Max of Average
Book Hard cover Plastic Soft Hard cover Plastic Soft
A 200 100
B 100 100
C 200 100
F 50 100
K 100 100
L 50 100
M 200 100
R 100 100
T 50 100
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top