Show data for all companies from a country when a company is selected

[#1]

I have companies as a dimension. When the user selects one company, I want to show the revenues for all the companies in the country the selected company is located in. Country is another dimension and each company has only one corresponding country attribute.

Perhaps I could have a country listbox in an alternate state, and have the corresponding country automatically be selected?

[Gysbert_Wassenaar · Accepted solution]

try something like:

=sum({<Company=,Country=p()>} Revenue)

Change the field names Company, Country and Revenue to the field names that match your situation