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