Divide some value of same column.

[#1]

Hi all

I have this pivot table:

In the column "Total" i'd like to divide each partial value of "Quota di Mercato" by Country, with total value of "Quota di Mercato" by Division.
For example:
- In corrispondence of "Belgium" i'd like to have: 0,09% / 2,11%

- In corrispondence of "Germany": 0,85% / 2,11%

- and so on...

I'm still not very good with the QlikView sintax expression, so i need help

[daveamz]

Hi,

To calculate the total of Quota di Mercato by division you can use sum(total <Division> Data).

Regards,

David

[#3]

I try to explain better:

I have this table where there are Product, Division and Country.

The expression to calculate "Vendite" (Sales) is the following:

=Sum(LineSalesAmount)

The column "Quota di mercato" (Market Share) is calculated as follow:

=Sum(LineSalesAmount) / Sum(Total LineSalesAmount) * 100

Now, i have to calculate "Indice di penetrazione" (Penetration Index).
The math formula is this :

PenetrationIndex = (CountryMarketShare / DivisionMarketShare) * 100

Can someone help me?

[swuehl]

As Daveamz01 mentioned, you can add a field list to the TOTAL qualifier, stating the dimensions that still need to be considered in your aggregation. So your Index could probably calculated like

=Sum(TOTAL<ProductName, DivisionName> LineSalesAmount) / Sum(TOTAL LineSalesAmount)

[Gysbert_Wassenaar · Accepted solution]

Something like:

CountryMarketShare / (sum(total <ProductName> LineSalesAmount)/sum(total LineSalesAmount))

see attached example.

[#6]

Thank you, it works perfectly