Value at date, Value Year -1 and Value Month -1

[guillaume_gorli]

Dear All,

I have a test database showing 3 informations :

Data

Part number

Value

I need to sum up in a chart (for a selected period) the value for each part number, the value for this part number at year -1 and the value for this part number at month -1.

For instance, if i do select April 2015 :

Knowing the database is :

the outcome should be the following...

... although what i come to is :

Several problems then :

• i don't want to see part number C in the chart as there is no value for C in April 2015 (the period selected)
• I need to see in the same raw the value for N and N-1 and not on separate ones
• Value for M-1 is not working at all

qvw and excel test database attached for the ones who want to help

Thanks in advance

[guillaume_gorli]

Any clue ?