Issue 125858

Summary:	Pivot tables-combining multiple sheets? - 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:24:32 UTC

Hi Folks,

How do I combine data from multiple sheets into a single pivot tables as shown in this video for Microsoft Excel.
http://computers.tutsplus.com/tutorials ... -cms-21190

I am stuggling to move a number of existing spreadsheets from Microsoft to OpenOffice and it seesm as if the Pivot Tables in OpenOffice are not as powerful, or it could be that I just simply can't find how to do this in OpenOffice so any pointers greatly appreciated.

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

Have been struggling all week on this work, :cry:

I have also posted this question in the user forum to see if there are other suggestions on how to achieve this

https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=73507

Thanks
Michael