Pivot Table two column sum
Thanks for the reply
This is my table
name price1 price2
d 11 5
d 11 5
e 13 4
This is Pivot Table I get
name Data Total
d Sum of price1 22
Sum of price2 10
e Sum of price1 13
Sum of price2 4
Total Sum of price1 35
Total Sum of price2 14
What should I do to represent it this way
name Sum of price1 Sum of price2
d 22 10
e 13 4
Total Sum 35 14
Thanks
Jim.
-----Original Message-----
Of I understand the situation correctly then:
select the Data button with your mouse and drag slightly
to the right and
release - you should see some "animation" around the
button to indicate the
intent is understood.
This should put make you data fields side by side rather
than stacked.
--
Regards,
Tom Ogilvy
Reg
"JIM.H." wrote in
message
...
Hello,
While creating pivot table, I am adding the sum of
first
price, which is perfectly ok, but when I add the sum of
other price in the same area, this new sum comes under
the previous sum instead of near it as a next column.
How
can I do this?
Thanks,
Jim.
.
|