AnsweredAssumed Answered

Data Entry on Total effecting only unlocked months

Question asked by dylan.fitzmaurice@lightarc.com.au on Oct 19, 2018
Latest reply on Oct 26, 2018 by amasiero

Hey Guys, 

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.

 

eg

Jan,Feb,Mar,Apr,May,June,July,Aug,Sep,Oct,Nov,Dec,Total

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:

Jan,Feb,Mar,Apr,May,June,July,Aug,Sep,Oct,Nov,Dec,Total

100,100,100,220,180,200,200,200,200,200,200,200,2100  

 

Because these months are locked on the cube it doesn't allow entry into the total. Is there a workaround or a way to setup the dataview to achieve the desired results?

 

Thanks in Advance,

 

Dylan Fitzmaurice

Outcomes