Hi, I have a table in datamodel like below
| Rec No |
product |
Flag |
| 1 |
AB |
0 |
| 1 |
AA |
0 |
| 2 |
BB |
0 |
| 2 |
BC |
0 |
| 3 |
CV |
0 |
| 3 |
CD |
0 |
| 3 |
CF |
0 |
| 4 |
GH |
0 |
| 4 |
GT |
0 |
| 4 |
GY |
0 |
| 1 |
AC |
1 |
| 2 |
BD |
1 |
| 3 |
CN |
1 |
i want output like below , because rec_no 4 should not share with both flag values , it has value 0 only
Remaining all records share flag values 1 and 0 both
| Rec_ No |
Product |
| 4 |
GH;GT;GY |
How to write chart expession in front end to get above output
