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: libreoffice-bugs@lists.freedesktop.org Reporter: mpa...@yahoo.com 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 Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs