How to display possible values within a straight table.?

[snehamahaveer]

Hi All,

I am creating a straight table that identifies customers who purchased products via specific discount codes.

So one of the expressions in my straight table should display all discount codes of a customer with comma in between.

eg the field should show as "DA,DB,DC".

Cust No	Cust Name	Year	Month	Sales Value	Qty	Discount Codes
1	Cust1	2017	May	1000	10	AS,DA,DC
2	Cust2	2017	May	5000	35	GA,GB,DC

Is there a simple way of achieving this?

Thanks and regards,

Sneha

[kaushiknsolanki]

You Can use the concate() function to get the comma separated values.

Regards,

Kaushik Solanki

[snehamahaveer]

Hi Kaushik,

Thank you.

I have over 100m lines of invoice and over 50 to 60 discount codes. The expression should identify the possible discount codes for the specific customer and display them.

I am not sure how Concat() would help with such a situation. Can you please explain.

Many thanks,

S

[kaushiknsolanki · Accepted solution]

Do you want to show all the discount codes of all the transactions against each transactions?

If yes then using the Concate() will be the best option in chart.

You will need to write the expression using the Total Keyword to get the possible codes for a customer.

Regards,

Kaushik Solanki

[tresesco]

Have you tried like :  Concat( Distinct [Discount Codes], ',')   ?

[snehamahaveer]

Thank you so much for the prompt help