LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 41
Default PivotTable Sum 2 Columns

Hi,
Probably this is simple.
You need to know first, I can not add another column in the Data sheets, I
need to work with the pivot table to do this.

I have a Pivot table with a field :" Status"
In this field the pivot table show 4 data: OSales, HSales, Refuse, Pending
Each data show 2 columns (# and %)
I need to add another column in the Pivot table showing the total of "Osales
+ Hsales" only
How can I add this
Here a small part of my Pivot tablet, save time and just show me, how to
create a total of the # forget the %
I will do the % base on this.

Status (Field)

OSales HSales Refuse Pending Total O&HSales
Total All
# # # # (This is what I need)
Ok I have it
1 2 2 1 3
6
4 2 5 3 6
14

Thanks


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get PivotTable data results to show in columns instead ro GeorgeK@Novagard Excel Discussion (Misc queries) 4 April 23rd 08 06:36 PM
Creating a PivotTable w/o selecting data in an existing PivotTable Damian Excel Discussion (Misc queries) 6 November 2nd 07 04:44 PM
PivotTable Farhad Excel Discussion (Misc queries) 1 October 24th 07 07:05 PM
Pivottable columns multiply in excel 2007 Haffi Excel Worksheet Functions 1 August 21st 07 04:32 AM
Show % between two columns in a pivottable dq Excel Worksheet Functions 2 May 7th 07 06:46 PM


All times are GMT +1. The time now is 05:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"