|
|
|
|
|
<Pivot table>.ListPositionHeader (Function) In french: <Tableau croisé dynamique>.ListePositionEntête Returns all values associated with a row or column header in a Pivot Table control. // Returns all countries displayed in the Pivot Table control arrPos is array of pvtPosition arrPos = PVT_Statistics.ListPositionHeader(COL_Country) FOR EACH dim OF arrPos // Displays the total for each country if > 10000 IF VAL_TO[dim] > 10000 Trace(dim.Country + ": " + VAL_TO[dim]) END END  // Returns all cities displayed in the Pivot Table control arrPos = PVT_Statistics.ListPositionHeader(COL_City) FOR EACH dim OF arrPos // Traces the French cities IF (dim.Country ~= "FRANCE") THEN Trace(dim.City) END END
Syntax
<Result> = <Pivot Table control>.ListPositionHeader(<Header>)
<Result>: Array of pvtPosition Array of pvtPosition variable containing the list of elements corresponding to the specified header. <Pivot Table control>: Control name Name of the Pivot Table control to be used. <Header>: Character string Name of the row or column header for which the different elements must be listed. This header must be visible and it must be displayed in the control. Remarks In the result array: - The headers of parents are filled.
- The headers of children or other axes have "*" for value (.Cumulated = True).
The same value can be returned several times with a different parent. For example, if we want to retrieve the list of vehicle models per country, the same model can be used in several countries.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|