Collapse the table of content
Expand the table of content
Expand Minimize
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer

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