Data provider types: Essbase, Planning (ad hoc only), Financial Management (ad hoc only), Hyperion Enterprise (ad hoc only)
HypPivotToPOV() pivots from the grid to the POV.
HypPivotToPOV (vtSheetName, vtSelection)
ByVal vtSelection As Variant
vtSheetName: The name of worksheet on which to run the function. If vtSheetName is Null or Empty, the active worksheet is used.
vtSelection: The range object that refers to the single cell starting point of the pivot. Orientation is calculated based on the selection.
Returns 0 if successful; otherwise, returns the appropriate error code.
Declare Function HypPivotToPOV Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtSelection As Variant) As Long Sub Example_HypPivotToPOV() X=HypPivotToPOV(Empty, RANGE("E6")) If X = 0 Then MsgBox("Pivot to POV successful.") Else MsgBox("Pivot to POV failed.") End If End Sub