Issue 125857

Summary:	Pivot tables, expand/collapse and filter ? - Feature request
Product:	Calc	Reporter:	michael.feehilly
Component:	ui	Assignee:	AOO issues mailing list <issues>
Status:	UNCONFIRMED ---	QA Contact:
Severity:	Major
Priority:	P3
Version:	4.1.1
Target Milestone:	---
Hardware:	PC
OS:	Linux 64-bit
Issue Type:	FEATURE	Latest Confirmation in:	---
Developer Difficulty:	---

Description michael.feehilly 2014-11-14 16:10:29 UTC

Hi Folks,

I am struglgling wit Pivot tables

How can I do expanding/collapsing and filters similar to what is shown in this video clip for Microsoft Excel
http://www.youtube.com/watch?v=zWknIrkMV6M

I am struggling badly here with Pivot table, in OpenOffice so would love to be pointed in the right direction :cry:

OpenOffice v4.1.1
AOO411m6(Build:9775) - Rev. 1617669
2014-08-13 09:23 - Linux x86_64

Redhat v6.5
Kernel 2.6.32-43.30.1.el6_x86_64
GNOME 2.28.2

I have also posted this on the user forum to see if there are other alternative ways of achieving the same effect.
https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=73504

thanks
Michael