Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Help
I have 2 columns in my pivot table (Columns F - "% of total return $" and
Column G - "% of sales for 2009") that is taking information from column C -"Net Return Dollars". I've made the pivot table to make column A of the table represent the Return Reasons and I've placed the sales numbers in a column of its own in the source data, but no in the pivot table itself. Here's the problem: I'm able to use the "% Of" function to figure out Column F which is based off of the total in column C (by return reason). But, I'm having problems getting percentages in column G which is essentially. the return $ by reason amount divided by the total sales for 2009. If you have any ideas as to how I can resolve this issue, I'd really appreciate your help!! Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Print Pivot Table headers on pages with Pivot Table | Excel Worksheet Functions | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel |