Pivot table

[tkaplan]

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

 

[Dave Peterson]

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

 

[tkaplan]

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]

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

 

[tkaplan]

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....%Total...%Total....%total..%region
.........................midw......$$$............$$$.......$$$........$$$.......sum
....................................%ofTotal....%Total...%Total....%total....%region
.........................south......$$$............$$$.......$$$........$$$.......sum
....................................%ofTotal....%Total...%Total....%total....blank
.........................west......$$$............$$$.......$$$........$$$.......sum
....................................%ofTotal....%Total...%Total....%total....blank
1
..............2
.........................east......$$$............$$$.......$$$........$$$.......sum
....................................%ofTotal....%Total...%Total....%total..%region
.........................midw......$$$............$$$.......$$$........$$$.......sum
....................................%ofTotal....%Total...%Total....%total..%region
.........................south......$$$............$$$.......$$$........$$$.......sum
....................................%ofTotal....%Total...%Total....%total..%region
.........................west......$$$............$$$.......$$$........$$$.......sum
....................................%ofTotal....%Total...%Total....%total..%region

 

[Dave Peterson]

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.