SET EXP

[lavielme]

Hay All

What Can I do If I need to calculate the last date for each company

depend on month selection

lats say

if i have

    Company, Date, Stoc

    X, 30/05/2016, 10

    X,01/06/2016,15

     X,05/06/2016,20

    Y, 31/05/2016, 20

     Y,25/05/2016,30

    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 Select jun

i will see

Company    Stoc

X                    20

AND If i will select may i will see

Company    Stoc

X                    10

Y                    20

Z                    30

Best Regards

Lavi

[oknotsen]

Do not start the same topic twice.

calculate the last date for each company

Locked.