Creating pivot subgroups

[#1]

hi..

I have a request to create pivot table with subgroups,

Ex : when we click on SEC memeber, we need to show region wise data (APAC, NA, EMEA etc..,) and when we click on region wise we should get data by countrywise.

Pls find the attachment for more info.

[hic]

If you

1. create a drill-down group (Settings > Document properties > Groups) using "SEC Member", "Region" and "Country"
2. Use this drill-down group as dimension

you will get exactly this.

HIC

[#3 · Accepted solution]

Thanks a lot Henric its so useful.

[#4]

I have one more question like...in pivot table in expression Dec is in one row and under this row permanent,temporary and total own in another row.

Please find the attached screen shot..

please help me.