PivotTable.AllocationValue Property (Excel)
Returns or sets what value to allocate 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 .AllocationValue
expression A variable that represents a PivotTable object.
Return Value
Remarks
The AllocationValue property corresponds to the Value to Allocate setting in the What-If Analysis Settings dialog box. The default setting is xlAllocateValue, which corresponds to the The value entered divided by the number of allocations setting.