Module name


Trigram: GCT




Visualize regional and sectoral sales volumes and values in a table:

  • Arrange the rows and columns of your table using your segments, your qualifying fields and your measures

  • Export your table to Excel

  • Create a favorite to view this table in routine

This sheet is for you if:

  • You want to create a dynamic table and view sales over 2 time periods (Example: 2017 vs. 2018, or April 2017 vs. April 2018) regionally and in sector

Data sources

Geographic territories

  • Metropolitan France data

  • Corsica

  • DROM-COM: Guadeloupe, Reunion, Martinique, Guyana


  • No limitation on the size of the markets

  • Applicable to human medicinal products, veterinary medicinal products and non-medicinal products



Territory Management Essential

Objects found in the sheet

  • Functional cartridge

  • Time buttons

  • Time selector

  • Indicator buttons

  • Company selector

  • Prescription selector

  • Territorial Selector

  • Network selector

  • KPIs

  • 'Indicators' Details' object



  • Day and week timing on option


09/10/2020: In case of sectorization on 3 levels (ex: Region, Area, Sector), this module has a known limitation preventing the display of the Region label within the pivot table.

As part of our policy of continuous development, an evaluation is underway in order to overcome the two-layer limitation of this module. We will inform you of its commissioning as soon as this limitation is lifted.


Current version:

Geographical Cross Table v2011120944

  • Added multi-converted units selector


Geographical Cross Table v2010121208

  • Update of the table to take into account the 3rd Layer if this one must be present. (Technical Note Intern: Region, vRegionField condition on v_txt_dim_title_Region).

Geographical Cross Table v2009281213

  • Modification of the structure of the pivot table in order to be able to choose precisely which columns to display or not.

Geographical Cross Table v2009231438

  • Integration of the 3 rd sectorization displayed conditionally. Is done by the AggrRegion variable initialized in the stream and whose lib is vRegionField (Internal Technical Improvement)

  • Switch to the new narrow grid modeled on Market Analysis (Internal Technical Improvement)

  • Addition of the Data Input Warning within the traceability cartridge. (Internal Technical Improvement)

Geographical Cross Table v2009181630

  • Modification of the structure of the pivot table in order to be able to choose precisely which columns to display or not.

  • Modification of the grid with the finest grain.

  • Addition of the warning of the Data Inputs of the module within the functional cartridge (traceability).

Cross v2007061705

  • Modification of the size of the Grid and the placement of objects closer to the original for the integration of the DOE (Internal Technical Improvement) cartridge

target"6Ge8sMv6C3cjLEcchBR9ag=186C3cjLEcchBR9agDbVUxEtable Geographical target

  • Implementation of dynamic reporting of the values of the analysis period type buttons.

Cross Table v2005051144

  • Module recieved on version target>

  • of the standard; no changes compared to the version v2004081147 of this module

Geographical Cross Table v2004081147

  • Revariability of the subscription within the cartridge. (New variable)

  • Change of the sheet icon

Geographical Cross Table v2003271914

  • Standardization of the placement of "Reload Time" on the SMA standard

Geographical Cross Table v2001071559

  • Variability of the labels of standard fields within the pivot table.

Geographical Cross Table v1909031709

  • Correction on the display of "Totals" for CQCPs displayed automatically

Geographical Cross Table v1908291024

  • Automatic reporting of hierarchical qualifying fields

Geographical Cross Table v1908091455

  • Fix for the link button to the success site

Geographical Cross Table v1905211427

Did this answer your question?