Adding values using MPCData formulas

To add a new value on the worksheet, you can copy and paste the MPCData formula and then manually change the members in the formula. You can also quickly populate an entire grid using only one inserted value and this shortcut method:

Use the Insert Value tab to add one value to the worksheet.
Within the MPCData formula, change the member name or cell reference for the on-grid Across dimension, for example this is the Period dimension, to a relative value for the column and absolute value for the row. The member name for the Accounting Periods Year dimension in the inserted formula is Total Year 2009.
For example, change "[Total Year 2009]" or $B$1 to B$1:
```
=MPCData("Sales BW250","[Period]",B$1,"[Unit]","[North America]","[Custom]","[Custom]","[Schedule]","[Sales]","[Measures]","[Value]","[Version]","[Actual]"]
```
Within the same formula, change the member name or cell reference for the on-grid Down dimension, in the example, this is the Unit dimension, to an absolute value for the column and relative value for the row. The member name for the Organization Unit dimension in the inserted formula is "North America."

For example, change "[North America]" or $A$2 to $A2:
Copy and paste by clicking and dragging the cell with the modified formula across the entire row and down the entire column to populate the data area. Then copy the top cell in each column down each column to finish populating the grid.