2 dimensions for value list

[ishanbansal1204]

Hi Experts,

I have been working on 1 dimension value list but the current requirement wants to me take up 2 dimension value list.

The first dimension is

=ValueList('A','B','C','D','E','F')

For the above value list, how do i create another value list against the value from the first

A    Z

A    X

B    Y

C    U

D    P

E    K

F   L

The output is given above.

[agigliotti]

why are you thinking to use ValueList for your use case?

[ishanbansal1204]

The current dashboard that i am working on is basically related to KPI's and it has 2 dimensions  and 5 different columns who values has to be calculated cell by cell.

Is there an another way of doing this.?

Please let me know if its possible?

Thanks,

Ishan

[agigliotti]

ok so you should add another ValueList dimension and check the combination of both dimensions values in your 5 measures expressions.

[ishanbansal1204]

Absolutely. Thats right.

[krishna_2644]

something like this?

[stascher]

If you know what the values are going to be, you might create a simple inline table and iterate over it's values.

Temp:

load * inline [

dim1,dim2

A,Z

A,X

B,Y

C,U

D,P

E,K

F,L

];

then use dim1 and dim2 in your visualization instead of value loops. May not work if you need actual relationship between dims and the data your measuring