xlAllocationValue

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

xlAllocateIncrementIncrement based on the old value (2)
xlAllocateValueThe value entered divided by the number of allocations (1)

xlAllocateIncrement
Increment based on the old value (2)
xlAllocateValue
The value entered divided by the number of allocations (1)

REMARKS
* Added in 2010.

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top