XlAllocationValue Enumeration
Specifies what value to allocate when performing what-if analysis on a PivotTable report based on an OLAP data source.
Version Information
Version Added: Excel 2010
Name |
Value |
Description |
|---|---|---|
xlAllocateIncrement |
2 |
Increment based on the old value. |
xlAllocateValue |
1 |
The value entered divided by the number of allocations. |