Report to pull multiple Product Categories/Organizational Units per project
We are facing the following issue.
We have created a Project and have associated multiple Product Category & Organization to this project, many to One relationship. This we have achieved through customization. When we are pulling report for this project through Reports-> Project Summary Extract. Itu2019s giving us only one Product Category & one Org Unit per Project. The business wants us to pull all the Org Units & the Product categories associated with the Project, when we are displaying the report. This org units & product categories will be shown in Org Unit & Product category columns respectively separated by commas.
Looking forward for your help.