Pivot Table - Macbook

%3CLINGO-SUB%20id%3D%22lingo-sub-2253871%22%20slang%3D%22en-US%22%3EPivot%20Table%20-%20Macbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2253871%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%20How%20can%20I%20create%20a%20pivot%20table%20with%20more%20than%201%20table%2C%20or%20with%20tables%20from%20different%20pages%3F%3C%2FP%3E%3CP%3EI%20can't%20find%20a%20solution%20to%20create%20it%2C%20as%20I%20can%20only%20select%201%20table%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2253871%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello! How can I create a pivot table with more than 1 table, or with tables from different pages?

I can't find a solution to create it, as I can only select 1 table

1 Reply

@RZMAGY Unfortunately, you cannot.That functionality is limited to the Windows versions of Excel. There you can load individual tables into a Data model, create relevant and appropriate relationships between them. Then you create pivot tables based on the entire model.