How to manage a writable 'recalc' measure
Hi all,
I hope that someone can help me.
I have the following measures:
Gross Sales Avg Price ==> Agg. type = recalc, Spread = none State = write
Sales U ==> Agg. type = total Spread = prop State = read
Gsls V ==> Agg. type = total Spread = prop State = read
Once the Gross Sales Avg. Price is planned, the Sales U is recalculated.
The user needs to plan the avg. Price at aggregate level on Calendar hierarchy and, the ideal behavoiur should be that
first the avg. Price is replicated down to the lowest level anf then the quantities are calculated.
At the moment the user is planning avg. Price measure typing 'r' suffix after the inserted value.