How to read appended Entries using VEC_LAYOUTVARIABLE_APP macro function

[Former Member]

Hi

For my SNP planning book, I have a requiredment to add multiple vector areas in a vector variable using vec_layoutvariable_app() function. I belive this macro function appends area key figures into vector like a two dimentional data. For instance I am going to use:

Action: Attach values to my_vector variable for a group of Products in the planning table

Step 1: Append group totals

VEC_LAYOUTVARIABLE_APP( 'MY_VECTOR' ;

Area:  [ $Sales Order ( INITIAL ) ; $Sales Order (  M 12/2014 ) ]

)

This will generate a vector variable MY_VECTOR which have values like:

M01/12	M02/12	M03/12	M04/12	M05/12	M06/12
1200	1300	5000	2000	1200	2000
1500	2000	3000	1000	1000	1500
2000	1500	2500	1000	2000	2200

But I do not know how to read this and assing to a Area: Key figure. If I use layoutvariable as shown below:

Area: Total Demand  (Forecast/Sales Order) ( INITIAL ) =

VEC_LAYOUTVARIABLE( 'MY_VECTOR' )

The above laoutvariable reads only the first row value.

I want to all three rows added and assign to Total Demand Key figure like:

M01/12	M02/12	M03/12	M04/12	M05/12	M06/12
4700	4800	10500	5000	4200	5700

Any idea on this? Appreciate your time and thanks in advance.