Data provider types: Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (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