restore the availability of the previous month as the existence of the following month

[Anonymous]

Hello everyone,



I have a pivot table divided by item, months, and ordered existence with the customer as the existence and availability calculated + orders.



How do I restore the availability of the previous month as the existence of the following month and so on?



Thanks to all

[swuehl]

Hi,

if I understood you correctly, you want to evaluate an expression in the context of a previous row  (like get the previous month availabiltiy, where previous month is determined by dimension of above row).

If so, I think the inter record functions will help you, e.g. above() function.

Stefan

[Anonymous]

Thank Stefan,

at end i have use the funcion BEFORE like this

= if( ColumnNo( )=1, sum(VARA) , before (VARB ))

VARA = Existence of  first month

VARB = existence + orders. of the month before.

Andrea