Creat a list box of groups of items

[Anonymous]

Here is my product list: AA111, AA112, AA113, BB121, BB122, BB123, CC131, CC132, CC133, DD141, DD142, DD143. You can see they are four different groups of products: AA, BB, CC, DD

I created a chart showing total sales for the four groups by month.

How can I create a Group field which contains AA, BB, CC, DD so I can assemble a list box of Groups? 

[Nicole-Smith]

I'm not sure what you're doing then.  In the right list box in my example .qvw, it lists the four groups...

[Anonymous]

It works now!! Thanks a lot, Nicole!!!