https://bugs.documentfoundation.org/show_bug.cgi?id=89398
Bug ID: 89398
Summary: Pivot Table cannot NOT calculate
Product: LibreOffice
Version: 4.3.3.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
LibreOffice 4.3.3.2 430m0(Build:2) pulled from Debian Jessie repos.
I have a tab with three columns of data: Name, lap_number, lap_time
I have 20+ athletes doing 10 laps and times for each of those laps unsorted.
Since there is no crosstab feature in base, I want a pivot table using name and
lap number as the row/columns and the intersection of name and lap is the lap
time.
Attempting to do this in libreoffice:
Using "pivot table layout" gui.
I can see my three fields populated under "Available Fields"
Drag Name to the "Row fields" box
Drag Lap_number to the "Column fields" box.
When dragging the lap_time field to the "Data fields" it forces a sum. I don't
need a sum. I need the lap time by lap as it appears in the third column.
Later on, hopefully, I can do some simple time differential math per athlete.
I can provide sample data, but not attached to the ticket as the adult names
are real. No other identifying information though, so I don't mind sending it
to an individual separately.
--
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
