Formula referenced to the Column containing Field name

[ziabobaz]

Can I reference in a formula the Column created through Valuelist, when this Column consists of Field names?

My try is not working.

Thank you!

[sunny_talwar]

From what I understand, you should be able to do this

[ziabobaz]

But it does not work in the example - it gives me zero.

First column is Dimension.

Column 1 (with Measure heading) contains the name of the field [Revenue]

Column 2 contains the formula: SUM( Column(1) ), but it returns null

I tried various things, like SUM ( '['&Column(1)&']' ) and on - still nothing.

Any suggestion?

Thank you.

[sunny_talwar]

Would you be able to share a sample?

[ziabobaz]

stalwar1

Please, see attached.

What i am trying to do is to create a column with fieldnames list through Valuelist and use it as part of the formula in another column.

Thank you.