PivotTable.AllocationMethod Property (Excel)
Returns or sets what method to use to allocate values when performing what-if analysis on a PivotTable report based on an OLAP data source. Read/write
expression A variable that represents a 'PivotTable' object.
The AllocationMethod property corresponds to the Allocation Method setting in the What-If Analysis Settings dialog box. The default setting is xlEqualAllocation , which corresponds to the Equal Allocation setting. If the AllocationMethod property is set to xlWeightedAllocation , which corresponds to the Weighted Allocation setting, you can optionally specify the weight expression to use by setting the AllocationWeightExpression property. If you do not specify a weight expression, a weight expression equivalent to
<leaf cell value> / <existing value> is used.