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.