https://bugs.documentfoundation.org/show_bug.cgi?id=172227
Bug ID: 172227
Summary: [PIVOTTABLE] Add filter for Total Result column
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
A PT currently accepts only field names for filter criteria. It is useful to
filter rows based on the value in the Total Result column of the PT.
For example, we may want to omit rows whose total is zero to focus on
"interesting" cases when reconciling accounts.
A workaround for the current version is to include a spreadsheet column in the
source data which is the sum of the other fields appearing in a PT view, and
this sum is a column which can then be filtered. This doubles the total of a PT
row, so we would want to turn off the "Show totals column" option in the PT
Layout window.
The main drawback of the sum column workaround is that sheet formulas must be
manipulated to change the selection of PT fields to total, whereas this is
automatic in a PT.
--
You are receiving this mail because:
You are the assignee for the bug.
