more than 1 valuelist ??

[hopkinsc]

Hi all,

How would i get a view like the following..

I assume its some sort of nested valuelist but unsure. 

Can anyone help please?

[sunny_talwar]

Not sure if nested valuelist will work or not, but have you thought about using an Island Table?

[hopkinsc]

Hi, do you mean use an island for the Sales, Margin £ and Margin % then a valuelist for the TY, LY etc?

[sunny_talwar · Accepted solution]

No an Island table with two fields

LOAD * INLINE [
Dim1, Dim2
Sales, TY
Sales, LY
Sales, Budget
...
GrossMargin, TY
GrossMargin, LY
...
GM %, TY
GM%, LY
GM%, Budegt
GM%, Target
];

[hopkinsc]

That's great, seems to have worked in a test doc. thanks!