Create a new line in dimension field created as an expression

[Anonymous]

All,

Is it possible to create a new line in pie chart dimension field created as an expression?

Eg:

something like this

=IF (LEN(field1) >0, field1&', '& chr(10) & chr(13) & aggr(COUNT(([key1])),[field1]))

Current Result value for Pie Chart Dimension:

JamesBond, 7

Expected Result value for Pie Chart Dimension:

JamesBond,

7

Thank you in advance

[Anil_Babu_Samineni]

Yes, Using this you can play?

=IF(LEN(field1) >0, Dual(field1&', '& chr(10) & chr(13) & aggr(COUNT(key1),field1), field1))

[Anonymous]

Hi Anil,

Tried it, but no success. I am looking for  aggregated count of all values of the key1 dimension grouped by field1 (not the dual value)