Hello All,

I have the following data as shown below:

I created the top 5 problem chart using the crystal chart which shows based on the no. of counts:

bar 1- top 1  problem - PASSWORD
bar 2 - top 2  problem - ERROR MESSAGE 
bar 3- top 3  problem - FAX
bar 4- top 4  problem - SECURITY
bar 5 - top 5  problem - AUTO LIMS

now i want to create the chart for just top 2 problem i.e ERROR MESSAGE

and show the Cause in the chart:

like how many (with their name) Cause are attached to ERROR MESSAGE

note that this sample data is in sorted form just for your understanding but the actual data when i pull from database comes in random form.

so i just need a general idea that i can create the chart i.e. create the chart for top 2nd and show the Cause attached to it.

can you help me.

thx :)))

Problem	Cause
AUTO LIMS	LOGIN
AUTO LIMS	LOGIN
AUTO LIMS	LOGIN
AUTO LIMS	NO INFO
AUTO LIMS	WRONG
ERROR MESSAGE	LOGIN
ERROR MESSAGE	LOGIN
ERROR MESSAGE	LOGIN
ERROR MESSAGE	NO INFO
ERROR MESSAGE	NO INFO
ERROR MESSAGE	USER ISSUES
ERROR MESSAGE	WRONG
ERROR MESSAGE	WRONG
ERROR MESSAGE	USER ISSUES
ERROR MESSAGE	WRONG
PASSWORD	USER ISSUES
PASSWORD	USER ISSUES
PASSWORD	USER ISSUES
PASSWORD	USER ISSUES
PASSWORD	LOGIN
PASSWORD	NO INFO
PASSWORD	USER ISSUES
PASSWORD	WRONG
PASSWORD	LOGIN
PASSWORD	LOGIN
PASSWORD	USER ISSUES
SECURITY	NO INFO
SECURITY	WRONG
SECURITY	WRONG
SECURITY	USER ISSUES
SECURITY	NO INFO
SECURITY	USER ISSUES
FAX	NO INFO
FAX	USER ISSUES
FAX	USER ISSUES
FAX	NO INFO
FAX	LOGIN
FAX	LOGIN
FAX	USER ISSUES