function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

reporting (record count) on picklist multi-select fields


--->(1) this is the situation:
* picklist multi-select with pick items x,y,z
* 5 selection possibilities: x,y,z,xy,xz,yz
* Lets say I have 4 records (i.e. 4 leads) with the following selections: x, xy, xz, xyz

--->(2) report: if I do a summary report on on this specific picklist multi-select I get the following record counts:
x = 1
xy = 1
xz = 1
xyz = 1

--->(3) Question: how do I get a report which counts the number for each single pick-item of a pick list "multi-select" and not the combination of pick items .... ? The 4 records mentioned above should be reported as:

x = 4
y = 2
z = 2

---> Thank you for your advice !

I have spent all morning looking for a solution to this problem.. i hvae found a few variations on this problem with no answer.

sorry i cant help but your way of phrasing the problem has so far best explained it.

it seems like something very simple fo salesforce to develop and the workaround of multiple custom fields is just way to clunky.

I'm sorry to hear you haven't found a solution, because I'm having the very same problem today! If you happen to find one, please post it here!

Tim McDTim McD

Having the same problem and would love to see a response