Accumulation Method

Syntax

object.Accumulation [Operand]

Applies To

Column Object

Columns

Row Object

Rows

Discussion

You cannot accumulate values over layers.

Depending on whether the method was applied to an object or a collection, the results are returned respectively as either an object or a collection.

The result of each calculation is stored in a new category which is added beside the Row or Column object, or to the end of the Rows or Columns collection.

When you accumulate the values in a collection, a new category is created for each object in the collection. For example, five columns are created when the Accumulation method is used in a collection of five columns.

References to the position of an object in the collection are not valid after you use this method.

Crossing accumulated categories produces an undefined result.

Notes

When you accumulate values in Explorer mode, the Summary Categories are exempt and therefore show N/A values. N/A values are also shown at the intersection point of a rank, other accumulation, or a business calculation such as Cumulative Percent of Base.

In Explorer mode, if more than one category is selected, the Accumulate calculation is disabled.

Return Type

Object

Example

This example returns an open report, accumulates all columns and all rows, and returns new rows and new columns.

Sub Main()

   Dim objPPRep As Object

   Set objPPRep = GetObject("C:\Cubes and Reports\Sample2.ppx")

   objPPRep.ExplorerMode = False

   objPPRep.Columns.Accumulation

   objPPRep.Rows.Accumulation

   Set objPPRep = Nothing

End Sub

Related Topics

• Methods
• Properties
• Column Object
• Columns
• Row Object
• Rows