https://bugs.documentfoundation.org/show_bug.cgi?id=155130
Heiko Tietze <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |INVALID Status|UNCONFIRMED |RESOLVED --- Comment #11 from Heiko Tietze <[email protected]> --- 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. -- You are receiving this mail because: You are the assignee for the bug.
