ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table Help (https://www.excelbanter.com/excel-discussion-misc-queries/260731-pivot-table-help.html)

Liz J[_2_]

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