I'm been scratching my head over this for a little while now. I have a pivot table with rolling weeks as the columns, and expressions as rows. The user needs to select a single product before he can see this table.
My first row is the opening stock balance, my second is sales, and my third is confirmed purchase orders for that specific week. This is where the problem comes in. The purpose of this table is to display the weeks when there will be no more stock (based on the opening stock balance - actuals + confirmed po's ) I use the following formula to calculate the following week's opening stock balance:
The problem is that my opening stock value is always the same, no matter which week I'm in, thus the formula works great for the week that it's in, but it doesn't take the "re-calculated" opening balance for the next week. So I was wondering if there is a way to get a cell value into an expression. Or if there are any suggestions on a work-around?
