Module Name
Trigramme : SCT
Tutorial
Screenshot
Value proposition
View sales volumes and value 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 module 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)
Data sources
Pharmaceuticals data
GSA drugstore data
Geographical territories
Metropolitan France data
Corsica
DROM-COM: Guadeloupe, Reunion, Martinique, Guyana
Market
No limitation on market size
Applicable on human drug, veterinary drug and non-drug
Status
Subscription
Sales & Marketing Essential
Objects in the sheet
Functional cartridge
Time buttons
Time selector
Indicator buttons
Company Selector
Prescription selector
Hierarchical selector
Network selector
'Sales Cross Table' object
Indicators
Sales volume
Sales value
Share of Contribution (Growth CTR)
Share of Adjusted Contribution (Growth CTR A)
Market Share (MS)
Market Share Delta - MS Delta
Options
Day and week temporality on option
International data on estimate
Limitations
Limitations related to the pivot table:
Inability to sort columns
Difficulty unrolling dimensions in a custom way (either all dimensions are closed, or all dimensions are open)
Export of data displayed in Excel on merged cells
Versions
Current version
Sales Cross Table v2007011744
Review of the positioning of objects according to the new grid in view of the implementation of the DOE (Internal Technical Improvement) cartridge
Old versions
Sales Cross Table v2006221015
Adding the Network filter in conditional display
Sales Cross Table v2006151637
Implementation of the conditional display of the Customer Type when there is one.
Sales Cross Table v2005191452
Variability of the labels of values of types of analysis period within the selection buttons.
Sales Cross Table v2005131416
Variability of the labels of the sheet cartridge.
Sales Cross Table v2004271727
Fix for Product_And_Code dimension for Product_and_Code
Sales Cross Table v2004161511
Change of the type of On / Off Prescription selector for Sales With Prescription / Sales Without Prescription (Now allows this selection to be taken into account within favorites)
Sales Cross Table v2002031030
Internal fix to the pivot table for the "Product And Code" field
Sales Cross Table v2001071559
Variability of the labels of standard fields within the "Company Details" pivot table.