|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
05-26-2005, 12:21 PM
|
|||
|
|||
|
pivot tables
i posted this on the general forum but i thought maybe someone here can help me.
I have a table that has four regions and total sales amount for each reason by week. my pivot table lists all those and totals it per region per month. i want to add in the pivot table a percentage of the regions sales for that one week over the total sales for all four regions. is there a way i can add that to the table? i.e. the table is currently like this: Week 1 East 500 Midwest 487 South 529 West 492 Total 2008 i want to add the percentages like this: Week 1 East 500 24.9% Midwest 487 24.3% South 529 26.3% West 492 24.5% Total 2008 (there are more columns in this table which is why i want to add a line underneath, not as a column next to the amount) thanks in advance 
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
