View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Cecilkumara Fernando[_2_] Cecilkumara Fernando[_2_] is offline
external usenet poster
 
Posts: 93
Default Pivot Table two column sum

JIM.H,
From the pivot table tool bar click on format report
select report9 or higher click ok.
don't like the format?
right click select = entire table
Edit clear = format
when refreshed you get the format back
In Pivot table options clear the
"Auto format the table" check box
HTH
Cecil

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