PivotTable.AllocationWeightExpression Property (Excel)
Collapse the table of content
Expand the table of content
This documentation is archived and is not being maintained.

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

expression .AllocationWeightExpression

expression A variable that represents a PivotTable object.

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.

© 2016 Microsoft