Pivot tables-combining multipl e sheets? - Feature request

[michaelff]

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,
Thanks
Michael

[Villeroy]

You can do this with vlookup formulas in the source range.
Of course it would be best to store data in a true database.

[Villeroy]

Oh, and you should post another enhancement request to this user forum: Calc does not have data pilot charts.

[michaelff]

Thanks for the suggestion, a bit cumbersome but may work