Dynamic Aggregation

[boopeshj]

Hey Experts, 

There are 4 fields. Need aggregation to show data as in the next table. 

F1	F2	F3	F4
F1-1	F2-Value	F3-Value	Country1
F1-1	F2-Value	F3-Value	Country2
F1-1	F2-Value	F3-Value	Country3
F1-1	F2-Value	F3-Value1	Country1
F1-1	F2-Value	F3-Value2	Country1
F1-1	F2-Value	F3-Value3	Country1

Want a straight table :

F1	F2	Required Expression
F1-1	F2-Value	Country1; Country2; Country3; F3-Value Country1; F3-Value1 Country1; F3-Value2 Country1; F3-Value3

I know it is possible to do it in the Load Script. But I want it to be dynamic. So if a user selects country1 then they should get only those projects.

[sunny_talwar]

Something like this?

With selection

[boopeshj]

 Thanks Sunny for the response. 

One small problem is that the result set should be one row instead of 4. 😞 

Thats the key challenge. 🙂 

[sunny_talwar]

Here is one row... bu the height of the cell won't adjust automatically

[Brett_Bleess]

Boopesh, did Sunny's final suggestion work?  If so, please be sure to give him credit for the help by marking one or both of his posts by clicking on the Accept as Solution button, so others will know as well.

Regards,
Brett