Sales Cross Table

Create a simple pivot table

Written by OpenHealth - Customer Success Center
Updated over a week ago

Module Name

Trigramme : SCT



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


DROM-COM: Guadeloupe, Reunion, Martinique, Guyana


No limitation on market size

Applicable on human drug, veterinary drug and non-drug



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


Sales volume

Sales value

Share of Contribution (Growth CTR)

Share of Adjusted Contribution (Growth CTR A)

Market Share (MS)

Market Share Delta - MS Delta


Day and week temporality on option

International data on estimate


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


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.

Did this answer your question?