https://bugs.documentfoundation.org/show_bug.cgi?id=97513
Bug ID: 97513
Summary: In Pivot tables, compute sum for numbers and counts
for other formats by default
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
When creating a Pivot table (Data->Pivot Table->Create) and adding a variable
(column) in Data Fields, Calc always computes the sum of values. This doesn't
make sense for columns which do not contain numbers, in which case the result
is empty. MS Excel retains a more natural behavior in that case: it
automatically chooses to compute the counts (of unique values) instead. In
Calc, one has to do so manually by double-clicking on the variable.
This would be particularly useful when the variable is an observation
identifier, which is a very common scenario (e.g. results from surveys, clients
database...).
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
