![]() |
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! |
All times are GMT +1. The time now is 05:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com