Hi, Hope someone could help me how i could calculate the "Weighted Average" in the following scenario in Pivot table. I could utilize the show value as function for % of Column Total and % of Parent Row Total, however how can i utilize these two column to add into the calculation field in Pivot table to derive the Weighted Average of % Score?
thanks so much
thanks so much
| Region/ Country | % of Column Total | % of Parent Row Total | Average of % Score | Weighted Average (% of Parent Row Total * Avg of % Score) |
| APAC | 3.29% | 3.29% | 68% | 2% |
| Australia | 0.96% | 29.09% | 74% | 22% |
| India | 0.96% | 29.09% | 96% | 28% |
| Singapore | 0.45% | 13.81% | 64% | 9% |
| Hong Kong | 0.41% | 12.33% | 41% | 5% |
| New Zealand | 0.17% | 5.23% | 23% | 1% |
| South Korea | 0.11% | 3.35% | 32% | 1% |
| Taiwan | 0.11% | 3.22% | 21% | 1% |
| Malaysia | 0.05% | 1.47% | 64% | 1% |
| Thailand | 0.03% | 0.94% | 29% | 0% |
| Philippines | 0.03% | 0.94% | 0% | 0% |
| Vietnam | 0.01% | 0.27% | 0% | 0% |
| Indonesia | 0.01% | 0.27% | 0% | 0% |
| Bermuda | 0.99% | 0.99% | 62% | 1% |
| Bermuda | 0.99% | 100.00% | 62% | 62% |
