Grouping selection.

[sibusiso90]

Hi all,

Please assist, I am trying to make a selection that selects all the groups where the selected is at.
E.G below

From above, when I select sale1 I want to see group2, group3 and group5 with all the information.

The output should be as follows.

stalwar1‌ tresesco‌

[sunny_talwar]

Are you making the selection in the chart itself?

[sibusiso90]

No, we will have a list box that they select from.

[sibusiso90]

This what I am working from.

[sunny_talwar · Accepted solution]

May be this

=Sum({<Sale, Group = {"=Sum(Value) > 0"}>}Value)

[sibusiso90]

stalwar1‌

Thanks you have been very helpful.

[sibusiso90]

Hi all,

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.

Attached is a model identical to my situation

stalwar1‌

tresesco‌

Thanks