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:
User Profile Reset: No
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:58.0) Gecko/20100101 Firefox/58.0
Ok, let's do it.
*** Bug 118575 has been marked as a duplicate of this bug. ***