I have a module that contains Cost Centers and Accounts and time dimensions. When user unticks a box called Override (line item), the values for combination of Account and Cost Center will be automatically populated using last 3m average values. If the box is ticked, then user is able to manually submit their own number (i.e. 3m average will be ignored).
Combinations of CCs and Accounts generates over 35000 rows, when I am trying to tick all the boxes I spend a lot of time copying and pasting ticked boxes, but I can only do a certain number of cells (there is a limitation when copying data). I wonder if there is an action that I can set up for this? I tried also excel add-in, but again due to amount of rows the upload crashes, and then I end up breaking down the work to smaller bulks of data which takes still time. Any ideas are appreciated! Thanks in advance.
