Hi @soham,
So if you mean to have a number of different category id’s, how do you expect to show in a visual with only one row; one category id value do you want captured for that individual row?
If you need it as part of your URL, will it make sense if it’s the same even though you have separate value options?
I’m not completely aware of how your aggregations will make sense to work along with your URL’s and how you want to group them so you may have to test out some various options but the reason for your separate/duplicated rows is due to aggregation happening in one field or another. I would suggest reviewing the attached documentation that helps understand aggregation functions and calculations a bit further that I think is very helpful.