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

            Bug ID: 173421
           Summary: Add a field-inspecific command for enabling subtotals
                    in a PivotTable
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

We support showing subtotals for field values for every row/record of a
PivotTable, individually via settings in each field's properties-options
dialog. But - there is no such command usable from a toolbar / Notebookbar Tab
(whether field-specific or pivot-table-wide). Also, the discoverability of the
per-field setting is lacking.

I suggest we have two commands, as well a toolbar widgets - one command for
subtotals of fields in rows and one for fields in columns - which enables or
disables them. UI-wise, there should be three states: no-subtotals,
not-uniform-subtotals-settings, all-subtotals (although one can wonder about
subtotals-on-top vs subtotals-on-bottom, but let's leave that out of this bug).

In MS Excel, this toggle has the form of items in a kind-of-a-drop-down menu on
the PivotTable Design (see attachment), also with the choice of whether
subtotals appear below or above.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to