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?
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.
Would you please upload the file and point to the problem?