Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Assuming your expression looks like this
Sum(Measure)
you need to add this set analysis
Sum({<Cities, Country = p(Country)>}Measure)
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.
You are doing this in a straight table, right? do you have an expression in a straight table?
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.
Check this out
Expression
Sum({<City, Country = p(Country)>}Sales)
Aaaaah. That was fast and amazing. Thank you...