Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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).