Share via


PivotTable.AllocationWeightExpression Property (Excel)

Returns or sets the MDX weight expression to use when performing what-if analysis on a PivotTable report based on an OLAP data source. Read/write

Version Information

Version Added: Excel 2010

Syntax

expression .AllocationWeightExpression

expression A variable that represents a PivotTable object.

Remarks

The AllocationWeightExpression property corresponds to the Weight Expression setting in the What-If Analysis Settings dialog box. Before the AllocationWeightExpression property can be set, you must set the AllocationMethod property to xlWeightedAllocation.

See Also

Concepts

PivotTable Object

PivotTable Object Members