use inputfield of previous month

[#1]

i have this situation:

inputfield A

LOAD * INLINE [

    YYYY,M, A

    2012,2, 20

    2012,3, 30

    2012,4, 40

    2012,5, 50

];

i need to use in a formula the value of the inputfiled A of the previous month compared to the month in column

example table :

month          inputvalue     value

3                 30               20

4                 40               30

5                 50               40

if I change the value of the inputfield for month 4 to 111 i need to see this value in the column of month 5

if I select a month the formula must work, so i cant use before or previous functions

in the attachment a qv doc that recreate the example

is it even possible?, thanks.

d.

[Gysbert_Wassenaar]

Try:

inputfield A

LOAD *, previous(A) as PreviousA;

LOAD * INLINE [

    YYYY,M, A

    2012,2, 20

    2012,3, 30

    2012,4, 40

    2012,5, 50

];

[#3]

it's an inputfield, i need to change the value in the presentation and use the changed value.

[Gysbert_Wassenaar]

You can try an set analysis expression.

=sum({<M={'$(=only(M)-1)'}>} campoInput)

[#5]

thank you again but i need to have the field M as dimension in my table and

set analisys does not work if you have the field you are selecting in set analisysy as dimension of the table.

[Gysbert_Wassenaar]

The set analysis expression works in a text box. See attached qvw.

[#7]

yes i know, but i need it in the table