PivotTable.MDX Property
Returns a String indicating the MDX (Multidimensional Expression) that would be sent to the provider to populate the current PivotTable view. Read-only.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
ReadOnly Property MDX As String
Get
'Usage
Dim instance As PivotTable
Dim value As String
value = instance.MDX
string MDX { get; }
Property Value
Type: System.String
Remarks
Querying this value for a non-Online Analytical Processing (OLAP) PivotTable, or when there is no PivotTable view (no data items), will return a run-time error.