Take a look at Debra Dalgleish's site:
http://www.contextures.com/xlPivot10.html

tkaplan wrote:

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...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=374139

--

Dave Peterson