Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate Nightmare! | Excel Worksheet Functions | |||
PivotTable Nightmare | Excel Discussion (Misc queries) | |||
PivotTable Nightmare | Excel Discussion (Misc queries) | |||
VLookup Nightmare! | Excel Worksheet Functions | |||
IF Statement nightmare | Excel Discussion (Misc queries) |