How can I show the grouped data in the row field of a pivot table? [closed]

asked 2014-06-30 15:59:14 +0200

momoi gravatar image

I'm working in a pivot table and some of the values fields are grouped when it's repeated. How can I show these grouped data? In the excel this kind of problem can be solved changing the print's layout, but in the libre office I didn't found the correct option.

My pivot table has a huge number of row in each row field, so the visualisation are really bad when the fields are grouped.

Can you help me?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-02-27 10:49:29.058345


I'm not sure about your wish. You should not assume, that people here know what Excel does. But perhaps it is this: Open the Options part of the pivot table dialog and check the option Enable drill to details. In the created pivot table double click a data field. That generates a new table containing all the details which are aggregated into this field. If you are looking for something different, please explain it in more details.

Regina gravatar imageRegina ( 2014-06-30 18:20:14 +0200 )edit

Would you please upload the file and point to the problem?

LKeithJordan gravatar imageLKeithJordan ( 2015-09-22 14:43:57 +0200 )edit