New measure depending on periode

[verocarbelo]

Hi COGNOSise team!

I am new in Data Manager and I would like to do this:

I have this table

PERIODE     PERIODE_VJ    KONTO    MEASURE1       MEASURE2

200803        200703     60000            100                     0

200703        200603     60000           24,5                     0

200603        200503     60000        200,14                     0

and I would like to add a new column with the measure of the same periode but one year before:
I mean:

PERIODE     PERIODE_VJ    KONTO    MEASURE1       MEASURE2

200803        200703     60000            100                 24,5

200703        200603     60000           24,5              200,14

200603        200503     60000        200,14                     0

How can I do this?

Thank you very much!! I hope someone can help me!!

[verocarbelo]

I can´t find the solution in DataManager.
Any ideas? :-[

[SSNCOG]

Do you want to add a new column in the table and populate the value ?
can you just show how different the table would be after the change.

Thanks,
SSNCOG