Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
try something like:
=sum({<Company=,Country=p()>} Revenue)
Change the field names Company, Country and Revenue to the field names that match your situation
try something like:
=sum({<Company=,Country=p()>} Revenue)
Change the field names Company, Country and Revenue to the field names that match your situation