Hi,
I have this problem. I have for example one
1st "data drop down list"- contries- it filter the
2nd. "data drop down list" - cities.
the "1st data dropdown list" control simultaneous one cross-table nest in a datadeck (?) with a lot of key performance idicators for contries.
And the "2nd data dropdownlist" control one another cross-table with key performance indicators for cities.
Also when I select "country" -America- the cross-table show the cummulated KPI of this country. And when I select New-York it change to the cross-table with KPI of this city.
how can i make the control to the cross-table?
thanks
You will need 2 queries.
Query 1 - Country and City
Query 2 - Country, City, and KPIs you want to see in Cross-tab
Create 2 Active Report Data Drop Down Controls
#1 Drag Country into the drop down area
#2 Drag City into the drop down area, drag County into the Extra Items area
#1 Create a connection and variable that will filter #2. Set County = Country
You should now have the cascading prompt.
Now add your cross-tab and associate to Query #2. Nest Country and then City in your rows. Add your KPIs as your columns.
Go back to your radio buttons:
Country Radio button - create a new connection, reuse the variable that cascades but apply filter to cross-tab. Country = Country.
City Radio button - create a new connection and new variable. Filter cross-tab on City = City.
Should get you want you want I believe. Let me know if that works.