Apr 05 2021 03:16 AM
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
Apr 05 2021 03:53 AM
@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.