I want to have 2 dashboards. The first one shows the monthly expenses for a selected organization code for a 12 month period. The organization code is selected from the dashboard prompt which selects the organization equal to the selection. The organization code is a series of characters. Each organization can have sub-organizations. A sub-organization starts with the same characters as the higher level org, with additional characters. For example, an organization with the code 'EA' can have sub-orgs 'EAA', 'EAB', 'EAA1' etc. Likewise 'EAA' can have a sub-orgs such as 'EAA1', 'EAAX' etc.
When a user clicks on a particular month in the first dashboard, it navigates to another dashboard. That dashboard shows the top ten sub-organizations ranked by expenses for a particular month. The prompt on that dashboard selects organizations that begin with (or are like) the selected organization code, and the month. The idea is it will show the top ten sub-orgs ranked by expenses, of the organization selected in the first dashboard.
What happens when it navigates to the "top ten" dashboard is that it initially only shows the organization equal to (not like) the organization from the first dashboard. The Organization prompt on that page displays the value from the first dashboard. However it doesn't seem to be using the prompt initially. When the prompt "apply" button is clicked, then it shows the sub-orgs. Is there any way to avoid having to click "apply"? I tried having the first prompt set a presentation variable and the in the second dashboard's analysis, having the Organization filter set to "begins with" the same presentation variable, but that doesn't work.
Thanks.