hi I have a category list in sharepoint and I have used it in repeating table in Infoapth with merge function. it gives me a string with multi selected value form category list.
I want to have report base on category list and the field.
I have tried a report and it gives me report like this

for example in category list I have:1-finance 2-IT 3-accounting
the result of repeating is :
1- finance;IT 2-IT;finance 3-accounting;finance

how to report how many has select finance


plz help me