xlAllocationMethod

Specifies the method to use to allocate values when performing what-if analysis on a PivotTable report based on an OLAP data source.

xlEqualAllocationUse equal allocation (1)
xlWeightedAllocationUse weighted allocation (2)

xlEqualAllocation
Use equal allocation (1)
xlWeightedAllocation
Use weighted allocation (2)

REMARKS
* Added in 2010.

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