Geographical Cross Table

Create a pivot table integrating your sectorization

Maxime LE MOIGNIC avatar
Written by Maxime LE MOIGNIC
Updated over a week ago

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:

  • Added multi-converted units selector


  • 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).

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

  • 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)

  • 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).

  • 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

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

  • Module recieved on version target>

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

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

  • Change of the sheet icon

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

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

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

  • Automatic reporting of hierarchical qualifying fields

  • Fix for the link button to the success site

Did this answer your question?