Returns the values of headers corresponding to a position in a Pivot Table control in pixels.
pos is pvtPosition of PVT_Statistics
pos = PVTInfoXY(PVT_Statistics, MouseXPos(), MouseYPos())
IF pos.Out = True THEN
STC_Caption = ""
ELSE
STC_Caption = "Year =" + pos.Year + ...
"Product = " + pos.Product + ...
"Sales = " + PVT_Statistics.VAL_Sales[pos]
END
Syntax
<Result> = PVTInfoXY(<Pivot Table control> , <X> , <Y>)
<Result>: pvtPosition variable
pvtPosition variable containing the characteristics of the selected cell. Remarks:
- If the position does not correspond to any cell of the pivot table (-1,-1), the Out property of the pvtPosition variable is set to True.
- The (0,0) position corresponds to the 1st cell at the top left.
<Pivot Table control>: Control name
Name of the Pivot Table control to be used.
<X>: Integer
X-coordinate (in pixels) to be analyzed. This coordinate is relative to the client area of the control.
<Y>: Integer
Y-coordinate (in pixels) to be analyzed. This coordinate is relative to the client area of the control.