Issue 125858 - Pivot tables-combining multiple sheets? - Feature request
Summary: Pivot tables-combining multiple sheets? - Feature request
Status: UNCONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 4.1.1
Hardware: PC Linux 64-bit
: P3 Major with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-11-14 16:24 UTC by michael.feehilly
Modified: 2014-11-14 16:24 UTC (History)
0 users

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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