Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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.
See attached
Yet another solution - and I attached the QVW too:
Hi,
one solution could be also:
hope this helps
regards
Marco