Apex Code Development You need to sign in to do that
Don't have an account?
SMARTrms 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
--->(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
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!
Thanks,
Rebecca
Having the same problem and would love to see a response