I was assisted yesterday with group selections but now I am stuck on how to apply it on my model as I use valuelist instead of a field as a dimension and I can't use cross table as it is a huge table with over 100 columns and about 1m rows which as growing daily.
The answered one is on the link below
Attached is a model identical to my situation
I made a mistake when I was explaining above sorry.
When you go the qvw I attached initially, Named "Selection by Group2.qvw". I will be using groups to select. That is the field I will be selecting with.