Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table two column sum
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table two column sum
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table two column sum
Just what I said. (Gets the basic layout)
then, you can right click in the pivot table, and select Options from the popup. Uncheck grand totals for rows Check grand totals for columns -- Regards, Tom Ogilvy "JIM.H." wrote in message ... 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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keep a column of comments "with" pivot table as pivot tables datachanges, causing rows to be added and deleted. | Excel Discussion (Misc queries) | |||
Pivot table column help | Excel Worksheet Functions | |||
column in a pivot table | Excel Discussion (Misc queries) | |||
Sorting a Pivot Table Column that is not the first column... | Excel Worksheet Functions | |||
Pivot Table - how do I add a column? | Excel Worksheet Functions |