Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I get PivotTable data results to show in columns instead ro | Excel Discussion (Misc queries) | |||
Creating a PivotTable w/o selecting data in an existing PivotTable | Excel Discussion (Misc queries) | |||
PivotTable | Excel Discussion (Misc queries) | |||
Pivottable columns multiply in excel 2007 | Excel Worksheet Functions | |||
Show % between two columns in a pivottable | Excel Worksheet Functions |