[Libreoffice-bugs] [Bug 140322] Calc subtotals: can't only show the last line (grand sum)

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Feb 22 23:25:40 UTC 2021


https://bugs.documentfoundation.org/show_bug.cgi?id=140322

--- Comment #4 from Shlage at gmx.com ---
(In reply to Roman Kuznetsov from comment #3)
> I checked back to 5.0 version and in every version I still see two rows with
> Subtotal when I click to level 1.
> 
> Question to bug reporter: how did you set up a group for level 1?
> 
> If I do some rework of your file then I get a needed result - I see only
> grand total for level 1

Please see the first 3 attached PNG screenshots showing how I created the
sub-totals.

I still cannot display the grand sum row only when clicking on level 1.

However, if I create a second (useless to me) group (see attachment #4),
clicking on level 2 will then show two grand totals lines (Grand Count AND
Grand Sum), and clicking on level 1 will show only Grand Sum.

You mentioned doing some rework on the sheet: Could you please give me the
details?

Thank you.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210222/e16f8cd1/attachment.htm>


More information about the Libreoffice-bugs mailing list