Chart problem! (1 Viewer)

[Bielmed]

Hello!
I have created a table in which I have a "multiple value field".
That means that a client may have "A" or "B" or "C", as well he may have "A and C", "A and B", "A, B and C", etc.
When I make a chart from that, to know how many of them have A, B and C, the ones that have more than one are separated. The ones that have "A and B" for an example, have a slice just for themselves, instead of being included in "A" and in "B".
How do I solve that?
Thank you.

 

[mcalex]

I think you need to change the table so it's only a 'single value field', and then use extra rows for clients with multiple letters.

You should then be able to identify not only which clients have multiple letters, but also, tally how much of each letter is being used individually.

hth
mcalex