Clicking on value will display all values based on other dimension value.

[retko1985]

Hello,

Here is a scenario what I want to achieve in straight table:

When I select a City in Cities Listbox, It will recognize which country the city belongs to, and in straight table display all cities in this County.

So when I Click New York, In straight table it will display all cities of the USA.

Please help. Thank you.

[sunny_talwar]

Assuming your expression looks like this

Sum(Measure)

you need to add this set analysis

Sum({<Cities, Country = p(Country)>}Measure)

[retko1985]

Hello,

I am not making any expressions. I just have a list of cities in straight table.

So, when I click in a Listbox with Cities it should show me in a straight table all cities in a recognized Country.

Thank you.

[sunny_talwar]

You are doing this in a straight table, right? do you have an expression in a straight table?

[retko1985]

Yes, there are expressions. Like basic sum.

I am attaching basic example. When I select for example New York, I want to see 3 rows in straight table - New York, Seattle and Washington.

Thank you.

[sunny_talwar · Accepted solution]

Check this out

Expression

Sum({<City, Country = p(Country)>}Sales)

[retko1985]

Aaaaah. That was fast and amazing. Thank you...