Trigram: SE

v2011101605

Tutorial

Screenshot

zoom

Value

The Sales Evolution sheet uses the principles of the Cross Sales Table sheet, by displaying a historical view

(Ex: week to week, or month to month):

  • Arrange the rows and columns of your table using your segments, your qualifying fields, your measures and time periods
  • Export your table to Excel. Create a favorite to view this table in routine
  • Select a custom time period (eg: I want to compare the first 4 months 2017 vs. 2018) by selecting the time periods directly in the sheet

This module is for you if:

  • You want to create a dynamic table and visualize sales over more than two time periods
  • It is also possible for you with a simple right-click to export the data of your stack-bar-histogram according to the temporal selections and desired filters.

Data sources

Geographical territories

  • Metropolitan France data
  • Corsica
  • DROM COM

Market

  • No limitation on the size of the markets
  • Applicable to human medicinal products, veterinary medicinal products and non-medicinal products

Status

Subscription

Sales & Marketing Essential

Objects found in the sheet

  • Functional cartridge
  • Temporal
  • buttons
  • temporal selector
  • GSA period time selector
  • Indicator buttons
  • Company
  • Prescription selector
  • Hierarchical selector
  • Network selector
  • KPIs
  • Object 'Evolution of sales in absolute value'
  • Object 'Pivot Table'

"NOT"

Indicators & measures

  • Volume Sales (VOLUME - Vol)
  • Sales Value (TURNOVER - To)
  • Market Share (N MS)
  • Market Share in the previous year (Market Share at N-1 - N-1 MS)
  • Market Share Trend compared to the previous adjacent month (Market Share Trend - MS Trend)
  • Market Share Delta in absolute value compared to the previous year (Market Share Delta - MS Delta)
  • N (Corresponds to the time selection and indicator to display made for the current year)
  • N-1 (Corresponds to the time and indicator selection to display made for the previous year)
  • Trend in percentage (N Trend)
  • Trend in absolute value (N Trend Abs)
  • Evolution of Turnover or Volume in percentage (N Evol)
  • Evolution of Turnover or Volume in absolute value (N Evol Abs)

Options

  • "Prescription" selector (Exclusively pharmacies data)
  • Customer Type (Pharmacies data only)

Compatibilities

  • NA

Limitations

  • NA

Version

Current version:

Sales Evolution v2011101605

  • Added converted multi-unit selector button

Old versions:

Sales Evolution v2009181528

  • Modification of the structure of the pivot table in order to be able to choose precisely which columns to display or not.
  • An enlargement of the table has been carried out by moving the bar graph up to the top line which was not used, this for a better readability of the figures within the table.

target15"43PDgh7F3KjlzSWcpUgJ9A target14"43 Sales15Angine>

  • Addition of the "Data Input" Warning in the traceability cartridge.

Sales_vank70 Sales_target"

  • Review of the positioning of objects according to the new grid for the implementation of the DOE (Internal Technical Improvement) cartridge

vank6a7bC0Rx"ElD15 vank6a7bC0Rx

Evolution> vank_ank6 target

  • Setting up conditional display for the Network selector.

Sales Evolution v2006151638

  • Implementation of the conditional display of the Customer Type when there is one.
  • Implementation of dynamic display of analysis period type selection buttons with parameter setting from the Param file

Sales Evolution v2005271724

  • Specific variability in v_Value_QTD under the label Qtr variabilisé v_lib_QTD.

Sales Evolution v2005191600

  • Variability of the labels of values of types of analysis period within the selection buttons.

Sales Evolution v2005140930
- Variabilization of the sheet cartridge, variability of the measurement label of the stacked bar-graph, as well as the labels of the measures of the pivot table.
- Variability of the title of the stacked bar-graph "Evolution of sales in absolute value".

Sales Evolution v2004271727

Evolution"https://openhealth.my.salesforce.com" Sales=SGgybl016 target1

  • Added N Trend Abs and N Evol Abs indicators in the details table.

vank target70"940> Evolution target Sales Target 70

  • Added labels to the "Evolution of sales in absolute value" stack-bar chart.
  • Variability of the subscription within the cartridge. (New variable)

Sales15ank Evolution target15AW710 vankM6Q9gNBSKE0AW710

Evolution_SQ9gNBSKE0AW710

Evolution

  • Variability of the labels of standard fields within the TCD and variability of the "Selection" dimension within the stack-graph histogram.

Sales Evolution v1909191553

  • Modification of the previous automation of the market qualifying hierarchical field selector for more speed when updating the App (dynamic value) (Internal Technical Improvement).

Sales Evolution v1909111730

  • Modification of the display mode selector with addition of hierarchical fields qualifying the market, automatically.

Sales Evolution v1909091509

  • Addition of totals for automatic CQCPs in pivot tables. (Internal Technical Improvement)

Sales Evolution v1908301048

  • Dynamic addition of the hierarchical market qualifying fields database (Internal technical improvement)
  • Stack-bar Evolution of sales in absolute value revised on Mth and Qtr formatting.

Sales Evolution v1908091455

  • Fix for the link button to the success site

Sales=3 vblank> Evolution

  • Reordering of the crosstab at the request of ND

Sales Evolution v1906061552

Sales Evolution v1905211400

  • Added link to Success site (top right)

target21>30_blank 90 Sales

  • Correction of the details table: Hiding values at "0" during a selection filtered on dimension.
Did this answer your question?