CalculatedMember Interface

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Represents the calculated fields and calculated items for PivotTables with Online Analytical Processing (OLAP) data sources.

public interface class CalculatedMember

[System.Runtime.InteropServices.Guid("00024455-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface CalculatedMember

Public Interface CalculatedMember

Attributes: GuidAttribute InterfaceTypeAttribute

Remarks

Use the Add(String, String, Object, Object) method or the Item[Object] property of the CalculatedMembers collection to return a CalculatedMember object.

With a CalculatedMember object you can check the validity of a calculated field or item in a PivotTable using the IsValid property.

Note The IsValid property will return True if the PivotTable is not currently connected to the data source. Use the MakeConnection() method before testing the IsValid property.

Properties

_Default	Reserved for internal use.
Application	Returns an Application object that represents the Excel application.
Creator	Returns a 32-bit integer that indicates the application in which this object was created.
DisplayFolder	Gets the display folder name for a named set.
Dynamic	Gets whether the specified named set is recalculated with every update.
FlattenHierarchies	Gets or sets whether items from all levels of the hierarchy of the specified named set are displayed in the same field of a PivotTable report based on an OLAP cube.
Formula	Returns the member's formula in multidimensional expressions (MDX) syntax.
HierarchizeDistinct	Gets or sets whether to order and remove duplicates when displaying the hierarchy of the specified named set in a PivotTable report based on an OLAP cube.
IsValid	Returns a Boolean that indicates whether the specified calculated member has been successfully instantiated with the OLAP provider during the current session.
MeasureGroup	Returns the associated measure group. Read-only.
Name	Returns the name of the object.
NumberFormat	Returns an XlCalcMemNumberFormatType value that represents the number format of the calculated member. The default value is xlNumberFormatTypeDefault. Read-only.
Parent	Returns the parent object for the specified object.
ParentHierarchy	Returns the name of the current parent hierarchy from the hierarchies that are available on the cube. Read-only.
ParentMember	Returns the name of the parent member for the parent hierarchy. Read-only.
SolveOrder	Returns an Integer specifying the value of the calculated member's solve order MDX (multidimensional expression) argument. The default value is zero.
SourceName	Returns the specified object’s name as it appears in the original source data for the specified PivotTable report.
Type	Returns the calculated member type.

Methods

Delete()

Deletes the object.

Applies to

Share via