Sections/Breaks In a Sheet

[#1]

I have a Pivot Table which has a 'Region' along the Top (AMERICAS, EMEA, APAC).

Does anyone know how this can be displayed whereby i have a separate table per region displayed one below each other?

[#2]

Have a calculated dimension in the table that returns something if the row is what you are after else returns null such as if (Region= 'AMERICAS', Region) then check 'suppress when value is null'.

You can then hide the column if needs be by setting its width to zero.

[#3]

That's Perfect Gordon. Works a treat.

Next challenge is to do the same thing with a Pi Chart I want to display alongside the table. Thanks for your help!