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:
Added multi-converted units selector
versions
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