Edit

Share via


PivotTable.AllocationValue Property

Definition

Gets or sets what value to allocate when performing what-if analysis on a PivotTable report based on an OLAP data source.

public:
 property Microsoft::Office::Interop::Excel::XlAllocationValue AllocationValue { Microsoft::Office::Interop::Excel::XlAllocationValue get(); void set(Microsoft::Office::Interop::Excel::XlAllocationValue value); };
public Microsoft.Office.Interop.Excel.XlAllocationValue AllocationValue { get; set; }
Public Property AllocationValue As XlAllocationValue

Property Value

An XlAllocationValue object.

Remarks

Read/write.

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.

Applies to