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

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

Thank you for your response.

Is there a way for me to make this come out in a second row instead of
in another column?

e.g.
have:
East ...........500
..................25%
Midwest ......487
..................24%
South .........529
..................26%
West ..........492
..................25%
Total ..........2008

instead of
East ...........500..........25%
Midwest ......487..........24%
South .........529..........26%
West ..........492..........25%
Total ..........2008

thank you


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=374139

You can drag the Data button to the row area, to arrange the data fields
vertically.

tkaplan wrote:
Thank you for your response.

Is there a way for me to make this come out in a second row instead of
in another column?

e.g.
have:
East ...........500
.................25%
Midwest ......487
.................24%
South .........529
.................26%
West ..........492
.................25%
Total ..........2008

instead of
East ...........500..........25%
Midwest ......487..........24%
South .........529..........26%
West ..........492..........25%
Total ..........2008

thank you




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

there are a few columns and rows that i need.

basically i need this layout:
The total column should be a calculation of the days columns per region
by week by period. the %total need to calculate that month's amount over
the total for that region. the %region needs to calculate the total from
that region (the sum above the line) over the subtotal for that entire
week.

period......week...region....0-29
days....30-60....60-90....over90....total
1
..............1
.........................east......$$$............ $$$.......$$$........$$$.......sum
....................................%ofTotal....%T otal...%Total....%total..%region
.........................midw......$$$............ $$$.......$$$........$$$.......sum
....................................%ofTotal....%T otal...%Total....%total....%region
.........................south......$$$........... .$$$.......$$$........$$$.......sum
....................................%ofTotal....%T otal...%Total....%total....blank
.........................west......$$$............ $$$.......$$$........$$$.......sum
....................................%ofTotal....%T otal...%Total....%total....blank
1
..............2
.........................east......$$$............ $$$.......$$$........$$$.......sum
....................................%ofTotal....%T otal...%Total....%total..%region
.........................midw......$$$............ $$$.......$$$........$$$.......sum
....................................%ofTotal....%T otal...%Total....%total..%region
.........................south......$$$........... .$$$.......$$$........$$$.......sum
....................................%ofTotal....%T otal...%Total....%total..%region
.........................west......$$$............ $$$.......$$$........$$$.......sum
....................................%ofTotal....%T otal...%Total....%total..%region


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=374139

I'm not sure you could do this and still have a pivottable.

But you could copy the pivottable, convert it to values and then reformat it
anyway you like.

tkaplan wrote:

there are a few columns and rows that i need.

basically i need this layout:
The total column should be a calculation of the days columns per region
by week by period. the %total need to calculate that month's amount over
the total for that region. the %region needs to calculate the total from
that region (the sum above the line) over the subtotal for that entire
week.

period......week...region....0-29
days....30-60....60-90....over90....total
1
.............1
........................east......$$$............$ $$.......$$$........$$$.......sum
...................................%ofTotal....%To tal...%Total....%total..%region
........................midw......$$$............$ $$.......$$$........$$$.......sum
...................................%ofTotal....%To tal...%Total....%total....%region
........................south......$$$............ $$$.......$$$........$$$.......sum
...................................%ofTotal....%To tal...%Total....%total....blank
........................west......$$$............$ $$.......$$$........$$$.......sum
...................................%ofTotal....%To tal...%Total....%total....blank
1
.............2
........................east......$$$............$ $$.......$$$........$$$.......sum
...................................%ofTotal....%To tal...%Total....%total..%region
........................midw......$$$............$ $$.......$$$........$$$.......sum
...................................%ofTotal....%To tal...%Total....%total..%region
........................south......$$$............ $$$.......$$$........$$$.......sum
...................................%ofTotal....%To tal...%Total....%total..%region
........................west......$$$............$ $$.......$$$........$$$.......sum
...................................%ofTotal....%To tal...%Total....%total..%region

--
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