Bug 115935 - PIVOT TABLE: add the option to link several tables as source on one pivot table.
Summary: PIVOT TABLE: add the option to link several tables as source on one pivot table.
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 118575 (view as bug list)
Depends on:
Blocks: Pivot-Table
  Show dependency tree / graph
 
Reported: 2018-02-22 12:43 UTC by m_a_riosv
Modified: 2018-07-08 14:10 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

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

Note You need to log in before you can comment on or make changes to this bug.
Description m_a_riosv 2018-02-22 12:43:18 UTC 
Description:
At this time pivot tables only work with one table at once.

Many time people need to use functions like VLOOKUP to merge data from different tables, and get summaries from such datas. If was possible to merge two or more tables by commons fields, will be a great simplification for many tasks and powerfull implementation for pivot tables.

It is already implemented in office. https://support.office.com/en-us/article/use-multiple-tables-to-create-a-pivottable-b5e3ff48-2921-4e29-be15-511e09b5cf2d?ui=en-US&rs=en-US&ad=US, so another compatibility task.

Steps to Reproduce:
.

Actual Results:  
.

Expected Results:
.


Reproducible: Always


User Profile Reset: No



Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:58.0) Gecko/20100101 Firefox/58.0
Comment 1 Buovjaga 2018-03-07 17:03:57 UTC 
Ok, let's do it.
Comment 2 m_a_riosv 2018-07-08 14:06:18 UTC 
*** Bug 118575 has been marked as a duplicate of this bug. ***