Page break setup

[kgcognos]

My requirement is to output to an excel
where
1 worksheet contains the Total Sales for All Regions
the next 9 worksheets contains Total Sales by Region  (1 worksheet per region)

First I created a page containing a crosstab. It is sectioned and pagebreak by region.
This works fine when outputted to an excel. It created 9 worksheets to separate the regions.

But then I cannot add another page to do the Total for Region since I'm already using pagebreak on the region.
I tried adding another query to the same page but it shows on each region worksheets . I could not get it to go in 1 worksheet.

Is it possible to create 1 data item that will contain a member from Company dimension and all members in company Region dimension?
I am thinking if I use this as column and page break on it, it will then create 1 worksheet for the company and 9 worksheets for the regions.

Any suggestion on how to get this to work. Thank you in advance.

Thank you




   

[kgcognos]

It works now. Earlier I thought I cannot add a new page. I was getting error when turning the View pages by tab property.

I just tried creating the page and NOT turn the View pages by tab property. It works now. My first page contains the total by company.
My second page is sectioned and page break by region.