pivot tables #9

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


-- 
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=22987
View this thread: http://www.excelforum.com/showthread.php?threadid=374143

0
5/26/2005 3:21:08 PM
excel.charting 18370 articles. 0 followers. Follow

0 Replies
714 Views

Similar Articles

[PageSpeed] 6

Reply:

Similar Artilces: