Text Expression

[#1]

Hello everyone,

How I can get the result of a text from an expression in a pivot table? My text is "SUM (A)", which I have saved in a field.

Regards, Daniel

[swuehl · Accepted solution]

Yes, you need to specify the sort weight in the concat, similar to what Miguel used, also in my variable:

=concat(FieldValue( 'FIELD2', valueloop(1,vMaxReg)),',',valueloop(1,vMaxReg))

edit: I attached my modifications together with Miguels suggestion.

edit2:

And as you see, Miguels expression is more simple, if you have a field F3. You could use mine without F3 if you change vMaxReg to something like count(FIELD2) (That's where I started from).