title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
---|---|---|---|---|---|---|---|---|
PivotTable.AllocationValue property (Excel) |
vbaxl10.chm235188 |
|
|
c68351d8-2959-46db-1f43-ca1bc71e14fc |
05/08/2019 |
medium |
Returns or sets the value to allocate when performing what-if analysis on a PivotTable report based on an OLAP data source. Read/write.
expression.AllocationValue
expression A variable that represents a PivotTable object.
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 setting The value entered divided by the number of allocations.
[!includeSupport and feedback]