Does anyone know how to accomplish this?
A pivot table counts the values as stored in the database (multiple values concatenated, separated by commas), I want to count them individually.
In this example, the counts should be as follows:
Value 1 = 3
Value 2 = 2
Value 3 = 3
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/19a91e39-8715-4d30-86ed-602824ea788f.png)
Best answer by lauraj46
View original