Displaying String In Chart Column on Conditional Match

[#1]

I am trying to create a chart that displays some text if a specific condition exists on the rows of data related to the record. For instance, there are a list of stores and there could be data for multiple mfgs for each store. I have a column for each Mfg and I want to display a string for each mfg if that row exists. If I change it to an aggregate of the Qty it shows a value show I know it sees the match but does not display the string.

[#2 · Accepted solution]

I figured it out. I used Concat() and chr(13) and it worked.