Description: When I generate a pivot table, I want the subtotals to be displayed at the top of the subsection and different coloring of the subtotal line Steps to Reproduce: 1.Cleare a spread sheet 2.Create pivot table 3.The table appears without subtotals for rows Actual Results: It comes without the subtotal rows and columns Expected Results: Should have subtotal rows Reproducible: Always User Profile Reset: No Additional Info: Lines hould be only for subtotals and not for all rows.
I'm not sure this should be as layout by default in Pivot table added UX team just in case
Thanks Roman Kuznetsov for taking a look at it quickly. It appears to be the default behavior in MS office and Google sheets. It need not be the default behavior in libre office, but it would be nice if there is an option to set the format as default. It would just make the migration from other office suites to libre office. Also, there a row group collapse option in Google sheets with a boxed minus sign.
Created attachment 187082 [details] Screen shot of behavior
Created attachment 187083 [details] Data to generate pivot table
So, instead of having to double-click on the Row Field in question, then choosing Subtotals > Automatic, you would like to have it as a default when there are several row fields?
Hi Ms. Stéphane Guillou thanks for getting back to me quickly. The short answer is yes. The collapsible nature of groups heads and distinct coloring very useful to quickly get group counts and drill downs. I mostly work with 30 - 50 groups max and less than 5 groups most of the time. I am not the best judge of what everyone wants, so I am requesting an option to set it as default, so that I don't have to go it manually every time I create a pivot table. It happens by default in competing commercial packages.
Hi Mr. Stéphane Guillou thanks for getting back to me quickly. The short answer is yes. The collapsible nature of groups heads and distinct coloring very useful to quickly get group counts and drill downs. I mostly work with 30 - 50 groups max and less than 5 groups most of the time. I am not the best judge of what everyone wants, so I am requesting an option to set it as default, so that I don't have to go it manually every time I create a pivot table. It happens by default in competing commercial packages.
[Automated Action] NeedInfo-To-Unconfirmed
(In reply to Stéphane Guillou (stragu) from comment #5) > So, instead of having to double-click on the Row Field in question, then > choosing Subtotals > Automatic, you would like to have it as a default when > there are several row fields? And I disagree with subtotals enabled by default. It can be easily done for only 5 clicks when you create the Pivot table. For example I don't need subtotals at all when I create me Pivot tables. I every time customize it by different options. May be some option like "Save pivot table creating options" can help here, I don't know.
Created attachment 187097 [details] 5 clicks for subtotal enabling
You are looking for the function Data > Subtotal. https://help.libreoffice.org/7.6/en-US/text/scalc/01/12050000.html (In reply to Yuwee from comment #4) > Created attachment 187083 [details] > Data to generate pivot table You are sharing an Excel sample? And the data are not well defined for pivoting; team 1..5 should repeat across the groups A..C. Resolving the ticket since we provide a function (Excel does too, if you prefer this application). Please reopen if something specific on the function is missing or I got your request wrong.
Too many comments at the same time... Could imagine Subtotals to be available on the Pivot wizard under options. But not sure this is satisfying for you.
Created attachment 187099 [details] Screen shot of excel default behavior
@Heiko Tietze sorry for uploading excel format. Could imagine Subtotals to be available on the Pivot wizard under options. But not sure this is satisfying for you. Yes. Definitely. I uploaded the default behavior of google sheet and MS excel just for reference and point out to the collapsible nature of row groups. The data is just dummy data I created so that I need share proprietary data on open forum. I have data that can be grouped by 4 different types of groups hierarchically.
Eike, was it ever considered to have an option in the pivot wizard to insert subtotals or is it easy to realize?
Any update on this Eike?
We discussed the topic in the design meeting and decided to follow Romans suggestion to not enable the subtotals by default. The feature is easy to enable once you know how to do it, for sure the dialog can be improved a lot, which is discussed in other tickets. The majority of users seem to be happy with the current implementation. And in case of many groups the decision for which one a subtotal is needed should be decided manually anyway. However, if more users request a subtotal sum by default this might be reconsidered.