Module name
Trigram: GCT
Tutorial
Screenshot
Value
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
Data from pharmacies
Geographic territories
Metropolitan France data
Corsica
DROM-COM: Guadeloupe, Reunion, Martinique, Guyana
Market
No limitation on the size of the markets
Applicable to human medicinal products, veterinary medicinal products and non-medicinal products
Status
Subscription
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
Indicators
Value sales
Options
Day and week timing on option
Limitations
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.
Versions
Current version:
Geographical Cross Table v2011120944
Added multi-converted units selector
versions
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).
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.
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