Hi everyone,

i am interested in an OLAP table, which counts lets say the number of apples in a basket. I have the number of apples put into the basket and the number of apples taken from it day by day. So, the formula would be:

Apples_in_the_basket(t)=apples_in_the_basket(t-1)+new_apples(t)-apples_taken(t).

Can it be implemented in the OLAP table?

Another Question is…for the very first row Apples_in_the_basket(t=0) I would need the initial number of apples, i.e. the number to start with. I would like to use a fixed number for that. Is it doable?

Best regards,

Maria