If your administrator has enabled Grid Spread, you can specify an amount or percentage to increase or decrease values across multiple dimensions on the grid, based on the existing values in the target cells. When calculating the spread data, read-only and locked cells and cells having supporting detail are ignored. Data integrity is ensured because values can be spread only to cells to which you have access.
To spread values using Grid Spread:
Put the cursor in the Subtotal or Total source cell whose value you want to spread to target cells.
From the Planning or Planning Ad Hoc ribbon, select Adjust, and then Grid Spread.
From the drop-down menu, select one of these options:
Value to increase or decrease values by a specified amount
Percentage to increase or decrease values by a percentage
Select Increase By or Decrease By and enter a value or percentage.
Proportional Spread to spread the value proportionally, based on the existing values in the target cells (the default)
Evenly Split to spread the value evenly among the target cells
Fill to replace the value in all target cells
Your administrator can add other spreading patterns.
Click Spread. The specified value or percentage is spread across the target cells, replacing former values with new ones