Setting the Amount

Amount specifies the source of the allocation. The amount value is allocated to cells in the target region. The amount, which can consist of upper-level or level 0 members, can be expressed as a numeric value expression, a tuple, or a constant.

How you express the amount determines certain requirements:

You can use these parameters to further define the amount:

You can use amount context and amount time span to achieve the same result, as shown in following example. The amount is the value of Dept_A, but amount time span is used to focus only on the months of Jan, Feb, Mar, and Apr for Dept_A. As shown in Table 215, the aggregated value of the members included in the amount time span (10) is the amount value that is allocated across the cells in the range.

Table 215. Example: Amount Time Span

Members in Amount Time SpanDept_A
Jan1
Feb2
Mar3
Apr4
Total10

You can achieve the same amount value by specifying amount as an arithmetic expression of Jan + Feb + Mar + Apr and setting the amount context as Dept_A, as shown in Table 216:

Table 216. Example: Amount Context

Amount ContextJanFebMarAprTotal
Dept_A123410