Hi,
I have searched the forum for solution but could not find anything.
I have the following situation.
Below you can see a report which contains request ID number, requester name and type of request.
Well below you may see summary of the report in the form of pivot table. The table contains count of ID numbers based on name and type criteria. For example, Parvin had 4 requests for the type of FO. What I need is to put actual ID numbers in the corresponding cell as comment. So, for those 4 requests the comment should contain
1930663; 1926508; 1926354; 1925646
ID Requester name Type
1930663 Parvin FO
1930222 Parvin OG
1930048 Parvin OG
1929218 Parvin OG
1928270 Parvin OG
1926727 Parvin CC
1926508 Parvin FO
1926354 Parvin FO
1926041 Parvin CC
1925793 Parvin OG
1925646 Parvin FO
1925562 Samir OG
1925557 Samir OG
1925534 Samir FO
1925411 Samir OG
1925410 Samir OG
1925401 Samir OG
1925399 Samir CC Sup
1925312 Samir CC Sup
1925213 Samir OG
1925207 Sara OG
1925206 Sara OG
1925157 Sara OG
1925128 Sara CC Sup
FO OG CC CC Sup
Parvin 4 5 2 0
Samir 1 6 0 2
Sara 0 3 0 1
I would appreciate if someone helps me with this.
Bookmarks