pivot table - more tables option

[lezawang]

Hi
I create a pivot table in a new sheet. Inside Fields sections there is an option called "More tables" (below fields list).
What that option is used for? I tried it but kind of got lost. Thank you so much.

 

[Worf]

That option is for the Data Model, which is used to create a pivot table from multiple source tables.


https://blogs.office.com/en-us/2012...e-data-model-and-relationships-in-excel-2013/

 

[danieleduardo24]

Hello, I was wondering how you can add the ‘more tables’ option under the PivotTable fields in Excel 2016 in macOS. I don’t have the option under my excel

 

[Worf]

Sorry, I do not know a thing about Macs.