Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Thanks for all your help
Hi.
You can try to use P() function, for example:
sum({<AGE_ID=,AGE_ID2=P(AGE_ID)>} $(varFatturato))
Thank you for your council.
In selecting AGE_ID2, i also considered the filter for AGE_ID. The result is not correct. How do I do that?
In the calculation of the Table 2, i must take only the records that have AGE_ID2 = AGE_ID
Thanks