I have a requirement to display in report of "count of each discount code applied"
We have two tables to join, IH table with Discount table. IH table contains multiple discount code as comma separed value for a single row. Discount table contains single discount code per row.
We need to fetch count for each discount code from IH table and display in report. Table format i tried to give below:
34DIS3, 34DIS4, 34DIS5
Approach we are following contains in report filter but thats not giving us correct result set.
Discount_List contains Discount_Code
Please suggest how to achieve the count of each discount_code from csv Discount_List
***Edited by Moderator Marije to add Capability tags***