I'm just looking for some help on how to optimize this dataview.
Right now the view is pretty basic.
Block 1: The cube to data enter into, by Account by Month by Cost Center, Locked by Cube in block 2.
Block 2: A cube to flag which months to locked, by month.
I want to be able to enter a value into the total column and have it distribute to get the desired total amongst the unlocked months only.
100,100,100,110,90,100,100,100,100,100,100,100,1200 with Jan,feb,mar locked
Enter in 2100 to get this result:
Thanks in Advance,