+ Start a Discussion
SMARTrmsSMARTrms 

reporting (record count) on picklist multi-select fields

Hello,

--->(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 !

Reto
vitekvitek
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.
rebeccarebecca
Vitek,

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!

Thanks,
Rebecca
Tim McDTim McD

Having the same problem and would love to see a response