xAvg Calculation in Pivot Table

  • Thread starter david_dzikowski
  • Start date
D

david_dzikowski

My company uses the following methodology for analyzing inventory data.
I'd like to be able to replicate this calculation *entirely* in a Pivot
Table. Any suggestions?

Step 1) Group and total averages are calculated.
Group_1: 90 average widgets
Group_2: 101 average widgets
Group_3: 150 average widgets
-------------------------
Total (for all items in Group_1, Group_2, and Group_3): 100 average
widgets

Step 2) xAvg is calculated for each group.
Group_1: (90 average widgets / 100 total average widgets) = 0.90
Group_2: (101 average widgets / 100 total average widgets) = 1.01
Group_3: (150 average widgets / 100 total average widgets) = 1.50

I have used the Average field setting in the Pivot Table. This provides
Step 1 (above) but not Step 2.

Any suggestions???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need % of row value in Pivot Table 0
Average of % in pivot table 1
pivot table % calculation error 4
custom calculation in Mutiple consolidation pivot table 0
Pivot Table Calculation 4
Pivot Table calculated field error 2
Formulas in Pivot Table 4
How to do counts, additions and averages in XCEL pivot table. 0

Top