Ask Your Question

Group data "summary rows below detail" option

asked 2017-02-13 10:32:26 +0200

stevedtrm gravatar image

I use excel for its group data "summary rows below detail" option which is critical to my work. Ive looked and cant find anything similar or even a request for it here. Is there a request and if not, how do i make one?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-02-13 22:40:49 +0200

m.a.riosv gravatar image
edit flag offensive delete link more


No, pivots are different to row groups. I cant remember how, but i remember the difference being huge. At least two differences:-

1) Row groups can be nested. 2) Row groups with rows below the detail are also in my excel files recognised incorrectly by libreoffice calc, displayed strangely as if the top row is the summary row despite it clearly not being.

Open a fresh excel file, put some random data around the page and then create nested groups.

Then save file and reopen in Libre Office calc

stevedtrm gravatar imagestevedtrm ( 2017-02-14 01:01:46 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-02-13 10:32:26 +0200

Seen: 134 times

Last updated: Feb 13 '17