Problem grouping taxonomy term and parent term in view

Hi all,

My view has only two two fields: business category and business type to display the categorys and subcategorys of businesses e.g. Property ¦ Estate agents or Legal ¦ Family lawyers, both fields are taxonomy terms, one is the parent of the other.

I can output the view as a table nicely with the first column of parent terms repeated for each different child term. All good.

Now all I want to do is group them so so that I get the grouping header of parent term followed by a number of rows of child term. Can't get it to work.

When is set grouping within style ¦ table settings, the view seems to be grouping by both terms and I get a group header of parent term for each child one not all related ones.

Recreated similar thing using nodes and worked fine. Exhausted my limited knowledge and well into the frustration zone now. Can anyone think of where I am going wrong?

Ultimately this is to be used with views accordian module but gotta get the basics working first!

Many thanks in advance,

Rich