Showing a level and its children one below other in crosstab .

[cognos05]

I have a level called acount and a top level called territory .

In a  crosstab instead of nesting the account within territroy users are asking to show all the accounts first and then the territory  .

If i put the levels one above other , then first it shows all the acounts for all territories and then all territories.

I want to show fist list of acounts for  1 territory and then have that territory below and then list of accounts for next territory and then its territory

Is there an option for this to work .

[cognos05]

Hi I was able t get this working by using

A query item   

Union ( Level 1 , Level2)
Then Using Hierarchize(Union(Levle1,Level2) ..

This works fine now showing my territory below it accounts one by one .

Now the problem I have is users wanted to sort all the accounts under terrirtory based on a product team sales ,

And if i sort my level1 based on product team its not reflecting after performing hierarchize.

I did a order by on Level1 code , but its not sorting the results.

If I nest the levels then the sort works. Now I wanted to know how to get the sort working on accounts when its shown one below the territory.