Sum of Columns in Pivot table

[#1]

Hi all, I'm not sure if I'm missing a trick but I have a requirement where I have to show the Sum of measures of a row in a Pivot table but with dimensions going across and the measures going down, e.g.

Any help appreciated!

Many thanks

[Digvijay_Singh]

Check this, I created variable in script and later used in expression -

[Digvijay_Singh]

Let vNoOfFields = NoOfFields('T1');

Let vConcat='';

For i = 1 to vNoOfFields-1

  Let vConcat = vConcat & 'Sum(['&FieldName(i+1,T1)&'])+';

Next

vConcat = Left(vConcat,Len(vConcat)-1);

[#4]

Yes I think building the string in the load script looks like the best approach, thanks for the tip!!!