Proportional data spreading method
The Proportional spread method distributes a specified value among cells proportional to existing cell values.
For example, consider the following view in which the values for Argentina in the months Jan, Feb, and Mar are 10, 30, and 60, respectively.
The sum of these values is 100, with the value in Jan accounting for 10% of the sum, the value in Feb accounting for 30%, and the value in Mar accounting for 60%.
When you proportionally distribute the value 300 across these cells and select the Replace update action, the result is as follows.
These values are proportionally equivalent to the values that existed before you apply data spreading.
- Jan contains the value 30, which is 10% of 300
- Feb contains the value 90, which is 30% of 300
- Mar contains the value 180, which is 60% of 300
To distribute the value 300 proportionally across cells, equivalent to the values that
existed before, type the following code:
P>300