xlAllocationMethod |
| Specifies the method to use to allocate values when performing what-if analysis on a PivotTable report based on an OLAP data source. |
| xlEqualAllocation | Use equal allocation (1) |
| xlWeightedAllocation | Use weighted allocation (2) |
| xlEqualAllocation |
| Use equal allocation (1) |
| xlWeightedAllocation |
| Use weighted allocation (2) |
| REMARKS |
| * Added in 2010. |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top