PivotTable Nightmare
 

Question: Does a PivotTable have the abililty to calcuate percentages if
it's not on the worksheet the PivotTable is based off of?

Problem: I have a spreadsheet that is totaling numbers for certain dates.
It has the formula to total and then I have a formula to calculate certain
percentages from the total based off of categories 1, 2, 3, and 4. What i
want is for the PivotTable to break down by categories and give the the total
for each category and a percent.

In desperate need of help.
--
Sandi Gardner

PivotTable Nightmare
 

A pivot table can summarize by category, and show each category as a
percent of the total column or row. There are examples he

http://www.contextures.com/xlPivot10.html

Sandi wrote:
Question: Does a PivotTable have the abililty to calcuate percentages if
it's not on the worksheet the PivotTable is based off of?

Problem: I have a spreadsheet that is totaling numbers for certain dates.
It has the formula to total and then I have a formula to calculate certain
percentages from the total based off of categories 1, 2, 3, and 4. What i
want is for the PivotTable to break down by categories and give the the total
for each category and a percent.

In desperate need of help.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

PivotTable Nightmare
 

Worked wonderfully from the link you suggested! Thank you sooo much!
--
Sandi Gardner


"Debra Dalgleish" wrote:

A pivot table can summarize by category, and show each category as a
percent of the total column or row. There are examples he

http://www.contextures.com/xlPivot10.html

Sandi wrote:
Question: Does a PivotTable have the abililty to calcuate percentages if
it's not on the worksheet the PivotTable is based off of?

Problem: I have a spreadsheet that is totaling numbers for certain dates.
It has the formula to total and then I have a formula to calculate certain
percentages from the total based off of categories 1, 2, 3, and 4. What i
want is for the PivotTable to break down by categories and give the the total
for each category and a percent.

In desperate need of help.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

PivotTable Nightmare
 

You're welcome! Thanks for letting me know that it worked.

Sandi wrote:
Worked wonderfully from the link you suggested! Thank you sooo much!


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html