Skip to Content
0
Former Member
Dec 08, 2009 at 07:16 AM

Categorizing via a field that has multiple entries

25 Views

I am out of ideas on this one. Please help.

I've got records in a SQL database. And I want to chart the total number of records by the Product field. The product field has multiple entries in it.

Product field entries can be Cells, Mods, Systems, EEs. Or, it can be a combination of these like: Cells, Mods

or

Mods, EEs

or

EEs, Mods, Systems

or etc...

I need to chart this by each products and not combination of these.

The Y-axis should contain the Sum, while the X-Axis should contain the 4 entries.

Right now, my X-Axis is showing combinations of the Products.

How do I go about this?

Thanks so much!