Module name




View all your standard indicators in a pivot table:

  • Choose your indicators, your dimensions and your measurements
  • Export your data in Excel format with and without totals

This module is for you if:

  • You want to extract a large amount of data on a regular basis

Data sources

  • GSA drugstore data

Geographic territories

  • Metropolitan France data


  • Applicable to human medicinal products, veterinary medicinal products and non-medicinal products



  • Sales & Marketing Advanced
  • RAW DATA option

Objects found in the sheet

  • RAW DATA table
  • Measurement selector
  • Temporal selector
  • Reference month selector

Indicators & measures

NB: the list of indicators and measures depend on the subscription.


  • Selling Digital Distribution SMKT
  • SMKT Selling Value Distribution
  • SMKT Monthly Average Sales
  • SMKT Adjusted Monthly Average Sales


  • 36 periods
  • Evolution of the current month
  • Mobile annual cumulative (CAM / MAT)
  • Rolling annual cumulative previous year
  • Evolution of the mobile annual cumulative
  • Fixed cumulative (CF / YTD)
  • Fixed cumulative previous year
  • Evolution of the fixed accumulation
  • Previous year
  • Year N-2
  • Evolution Year

Compatible Options

  • Product qualifying fields
  • Favorites


  • Slow data display on full visualizations
  • Exporting one indicator at a time


target= AIA v2011041058

  • Addition of the Warning "No Compliant Data Input" at the top right.

target=200"_bl4IOE" target>200"_block17 : Addition of a reference period selector

Old versions

v2OzR3utqvICo _200727 target vI7ymt6q3jn3VUlAeTctQDZXVFR2OzR3utqvICo v4277 target17 : Change in the method of calculating SMKT indicators

target> v227JoXTNSY00" target : Correction of conditional display problem SMKT period

v2002172304: First version of the module

Did this answer your question?