My Dataset is like below.
| Product |
| Apple,Orange |
| Apple |
| Orange |
| Orange, Banana |
| Banana |
| Apple,Orange,Banana |
Then I create a new dimension : SubField([Product],',',1) as New Product.
| Product |
| Apple |
| Orange |
| Banana |
May i ask what expression that i can use to count the product . I want the result as below.
| Product |
Count |
| Apple |
3 |
| Orange |
4 |
| Banana |
3 |
