Hi,
Is there any formula or function how to (semi-)automatically delete all sub-groups rows(and leave only main data)?
excel outlining.png

Eg I have the following rows:
total revenue
revenue in Europe
revenue in Nordic
revenue in Rest of the world

I have created groups. Now I need to send this report in Excel file to my colleagues and I would like to show them only the total rows (tabel2 in attached picture). Do I have to delete the detail data rows one by one manually or there is some helpful function for doing that (or for selecting such rows together).

Thanks in advance!
Reena