User,msg no,comments abc,101,xyz abc,102,xxx bac,105,xlx
Expected Output :
User,msg no,comments abc,101,xyz abc,102,xxx abc=2 bac,105,xlx bac=1
Please help me to count the number of columns and display the sum as mentioned in the expected output
Create group by band with User .
Group by band will have header and footer section.
In group footer, drag teh "user" field and drage "user" or "msg" field. When dragging "msg" field the studio engine auto create a variable and ask you for the type of calculation. In your case take count.
It should solve your problem.