Relationship between tables

[#1]

Hi all.

I'm trying to solve this problem.

How do I cross the tables below to calculate:

Full potential of 2015

(Answer should be 800)

or Full potential by product

   (Answer should be A = 3700 ; B = 300)

Tks a lot!!

Sales per Year

City	Cód	Year of Production	Qtd
São Paulo	1	2015	5
Rio de Janeiro	1	2014	3
São Paulo	2	2014	7
Rio de Janeiro	3	2013	10
Rio de Janeiro	6	2015	5

Models

Cód	Product
1	A
2	A
3	A
4	A
5	B
6	B
7	B

Potential of maintenance

Product	Year	Potential
A	2015	100
A	2014	150
A	2013	170
B	2015	60

[#2]

Hi,

Try this (it's not very elegant but it should work) :

Full potential of 2015:

=sum({<[Year of Production]={"2015"}>*<[Year]={"2015"}>} Potential*Qtd)

Full potential by product:

=sum(if([Year of Production]=Year,Qtd*Potential))

Xavier.

[Anonymous]

See attached

[petter]

Yet another solution   - and I attached the QVW too:

[MarcoWedel]

Hi,

one solution could be also:

hope this helps

regards

Marco