SET EXP

[lavielme]

Hey everyone

Lats say i have this data:

Company	Date	Stoc
X	30/05/2016	10
Y	31/05/2016	20
Z	31/05/2016	30
X	30/04/2016	40
Y	01/05/2016	10
Z	02/05/2016	30
X	28/03/2016	40
Y	31/03/2016	50
Z	31/03/2016	10
X	27/03/2016	20
Y	31/03/2016	30
Z	01/04/2016	40

and i need an expression who can Calculate For each Company the last stock in a table for example if i don't choose anything

the table will be like that:

Company     Stoc

X                    10

Y                   20

Z                    30

If i choos march and aprill

Company     Stoc

X                     40

Z                    40

Y                    0

Best Regards

Lavi

[lavielme]

That was what i looking for todat