Export (0) Print
Expand All
Expand Minimize

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 Added: Excel 2010

Name

Value

Description

xlEqualAllocation

1

Use equal allocation.

xlWeightedAllocation

2

Use weighted allocation.

If the AllocationMethod property is set to xlWeightedAllocation, you can optionally specify the weight expression to use by setting the AllocationWeightExpression property.

Show:
© 2014 Microsoft