次の方法で共有


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

XlAllocationValue

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.

See Also

Concepts

PivotTable Object Members

PivotTable Object