2 Replies Latest reply: Feb 12, 2014 9:44 AM by Manuel Raggi

# Help for formula for calculating turnover on two dimensions associated with the same fact table

Hello to all.
I have the following data structure:

I must get the total  turnover  for AGE_ID and AGE_ID2  into two separate tables.

Estrvenstor is the  table Data.

Table 1                                                Table2

AGE_ID  Turnover                               AGE_ID2   Turnover

101         1.100                                   101           2.100

The two results should be obtained without the filter of the for AGE_ID influences the selection of the records of the second table which must be filtered for AGE_ID2.

Inizio modulo

It is possible to get it with the associative structure attached ?

In addition, the value assumed AGE_ID must then also be the value of filter for AGE_ID2.

Example.

AGE_ID = 101 (active filter)

Table 1

sum({<AGE_ID={"=\$(=(AGE_ID))"},AGE_ID={"<>null"}>} total <AGE_ID> \$(varFatturato))

I tried to use the following formula but it does not work!

For table 2 that formula should I use ?

• ###### Re: Help for formula for calculating turnover on two dimensions associated with the same fact table

Hi.

You can try to use P() function, for example:

sum({<AGE_ID=,AGE_ID2=P(AGE_ID)>} \$(varFatturato))