6 Replies Latest reply: Jul 31, 2017 12:30 PM by Retko Okter

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

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.

• ###### Re: Clicking on value will display all values based on other dimension value.

Assuming your expression looks like this

Sum(Measure)

you need to add this set analysis

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

• ###### Re: Clicking on value will display all values based on other dimension value.

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.

• ###### Re: Clicking on value will display all values based on other dimension value.

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

• ###### Re: Clicking on value will display all values based on other dimension value.

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.

• ###### Re: Clicking on value will display all values based on other dimension value.

Check this out

Expression

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

• ###### Re: Clicking on value will display all values based on other dimension value.

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