Properties specific to the description of pvtPosition variables

Operating mode

• specify the values of headers for the desired cell. For example:
  
  MyPosition is pvtPosition of PVT_Statistics
  // Indicate the headers
  MyPosition.COL_Continent = "Europe"
  MyPosition.COL_OrderDate_Year = "2012"
  
• access a value of the pivot table via the following syntax:
  
  <Name of pivot table>.<Value name>[<pvtPosition variable>]
  
  For example:
  
  // Retrieves the "VAL_Qty" value
  nQuantity = PVT_Statistics.VAL_Qty[MyPosition]
  

• If the position does not correspond to a displayed cell (because the cell is collapsed for example), you cannot retrieve the value of the cell or modify its color.
• If the position does not correspond to a value that exists in the result (a product that was not sold this particular day for example), the returned value is 0.
• If the position has a header name that does not exist in the pivot table, a WLanguage error is displayed.
• A WLanguage error occurs if the position is outside the pivot table.
• To get a cumulated total on a header, specify no header or set .Cumulated to True.
• The .Out property can be used to determine if the position returned by PVTInfoXY exists.

Case of pivot tables with filter

Modifying the characteristics of a cell

Functions that use pvtPosition variables

Versions 18 and later PVTInfoXY New in version 18 PVTInfoXY PVTInfoXY	Returns the values of headers corresponding to a position in a Pivot Table control in pixels.
Versions 19 and later PVTListPositionHeader New in version 19 PVTListPositionHeader PVTListPositionHeader	Returns all values associated with a row or column header in a Pivot Table control.
Versions 19 and later PVTSelect New in version 19 PVTSelect PVTSelect	Allows you to find out the position of selected cells and to select cells in a Pivot Table control.