Section Link on Crosstab

[AshleyP]

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?

[Sam_SAS · Accepted solution]

Hello Ashley,

I am not an expert on the report designer but as I understand it, you can only link from a crosstab by double-clicking a specific cell. The row and column headings do not link.

I don't know if this would be helpful, but you could put a bar chart on the same section with the same data roles, and assign the section link to the bar chart.

Maybe someone else can offer a better workaround?

Thanks,
Sam

[SAS_Mike]

Hello,

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.

Mike

[AshleyP]

Mike,

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.

Regards,

Ashley

[AnnaBrown]

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.

Thanks!

Anna