Calculated Field UDF in Pivot Table

[amaru]

Hi,

Trying to add a UDF formula for calculated field in a pivot table.

UDF = concat('existing field', ","). The UDF concat concatenates a range of cells with a delimiter, in this case a comma. Say the 'existing field' is a column of strings.

Calculated field formulas seem very limiting in scope. I want to avoid converting the pivot table to values. Using a udf on the aggregation of data seems like a logical extension of a pivot table capabilities.

Question: will the above udf work in a pivot table? Willing to post an example if required.

 

[RoryA]

No it won't work. You can't use a UDF in a calculated field. Even if you could that one returns text which would be no use.