I have a xml table displaying certain fields from my odata. The data in the fields have duplicates (PFA). I want to group those duplicates displaying them only once and also pass the count of their occurence as a table field.
Please provide your suggestions as to how this can be accomplished, I have been sitting with this for quite sometime.
Note: In the attachment I have a repetitive occurrence of Power Wheel Chair which comes from the odata. I want to group them together and display only once. Further I also want the count of their occurence.