Notifications
Clear all
Topic starter
I have Excel 2010
I need to add two tables with an ID + a sum for a single pivot table that will sum up their shares and show the sum of the two tables for each identity card.
In the Add Pivot Table pane, do not have the Add this data to the data model command
How do I do this in Excel 2010? Thanks
Posted : 24/03/2019 2:12 pm
Hello,
This blog article gives a good answer on which Excel versions have PQ or not.
https://www.myonlinetraininghub.com/power-query-version-compatibility-and-installation
Br,
Anders
Posted : 25/03/2019 10:41 am
Can you post a sample workbook? It may be possible to do what you want with a consolidation range pivot table, if you can't download Power Query or Power Pivot.
Posted : 26/03/2019 4:49 am
