10-28-2015 08:09 AM
I have a Crosstab which summarises Monthly Sales by Country. Country is down the page, Month is across the page.
I have created a Link to another Section as I want the user to be able to double click on the Country so they can display the same Crosstab in the linked Section, but this time at Region level (Region is next layer down below Country). However, I only appear to be able to double click on one of the Month values, which then takes me to the linked Section, by Country but only dosplays the Month I have double clicked on.
Can I create a Crosstab Link to another Section, also a Crosstab, without selecting a specific column (Month) value?
10-28-2015 09:53 AM
10-28-2015 09:53 AM
11-03-2015 04:14 PM
If I understand what you are trying to accomplish, it is less about linking to another Cross Table, and more about being able to drill down. I loaded a very basic test file with only the data you mentioned and created a hierarchy First by country and then added region. If you add the hierarchy in, it allows you to select the plus button to the left of the name which will then let you expand the selection to see the region. There is also a drill down button that lets you only focus on the regions for that country.
You can create the hirearchy by selecting options in the top left. You will need to select the country category first, and then the regions category. Then you add it in like normal, only now you will see the expand and drill down option next to the country name.
Hope this helps.
11-05-2015 05:13 AM
Many thanks for taking the time to reply and provide an example of how to do this.
Your suggestion is a very good alternative way to do what I need.
I didn't actually realise that you could use a hierarchy in a cross-tab as a replacement for Categories (in this case Country and Region). I incorrectly thought that you had to overlay the hierarchy on the report after adding the columns/rows so this is very useful information for me.
11-05-2015 06:14 AM
I'm glad you found a way to accomplish what you were looking to do, AshleyP! Can you "accept Mike's answer as a solution"? That will help other community members if they run into the same thing.