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
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