Hi all,
I have data for countries and I want to group the European ones and to show a subtotal. So my table rows would be something like.
Europe
UK
France
Germany
Italy
US
Japan
China
I easily created a Europe group through right clicking in the field list. However, when I put them both in the rows area and use the "Expand all down one level in the hierarchy" I get something like@
Europe
UK
France
Germany
Italy
US
US
Japan
Japan
China
China
Is what I want to do possible?
Edit: My indentations above didn't work. Hopefully it's clear what I am getting at.
I have data for countries and I want to group the European ones and to show a subtotal. So my table rows would be something like.
Europe
UK
France
Germany
Italy
US
Japan
China
I easily created a Europe group through right clicking in the field list. However, when I put them both in the rows area and use the "Expand all down one level in the hierarchy" I get something like@
Europe
UK
France
Germany
Italy
US
US
Japan
Japan
China
China
Is what I want to do possible?
Edit: My indentations above didn't work. Hopefully it's clear what I am getting at.
Last edited: