valueloop issue

[#1]

Hi experts,
I'm trying to create a kpi metrics table as shown below

Header 1	Header 2
Sales	1000
Quantity	10
Revenue	1100

I tried to uuse valueloop and pick functions but failed to achive desired list.

Below are steps i followed

Create dimension1 : valueloop(1,3)

1st expression: Pick(ValueLoop(1,3),'Sales','Quanitity','Revenue')

2nd expression: pick(valueloop(1,3),sum(sales),sum(Quantity),sum(Revenue))

I'm getting only sum(Sales) value remaining two rows are blank, can you please let me know if I missed anything.

[sunny_talwar]

It seems to be working for me:

[#3]

Thx Sunindia,

not sure why I'm facing the issue,is it beacuse of varibles I'm using not direct column.

[sunny_talwar]

So you are using variables instead of directly using the expressions? But I have seen the variables working also, may be you need to tweak them to make them work. Can you share the file you are working on if its not too big or confidential?

[ramoncova06]

I was having the same issue by having this as a calculated dimension, if you switch it to the expression it works flawlessly

[sunny_talwar]

I used variable instead of directly using ValueLoop and it seems to be working well: