XlAllocationMethod Enumeration
Specifies the method to use to allocate values when performing what-if analysis on a PivotTable report based on an OLAP data source.
Version Information
Version Added: Excel 2010
Name |
Value |
Description |
|---|---|---|
xlEqualAllocation |
1 |
Use equal allocation. |
xlWeightedAllocation |
2 |
Use weighted allocation. |
Remarks
If the AllocationMethod property is set to xlWeightedAllocation, you can optionally specify the weight expression to use by setting the AllocationWeightExpression property.