Log In
Register
Home
May 27, 2014
Offline
I need to consolidate two Pivot Tables; summing the values on the two reports and with unique values in rows from the two reports and this new Pivot Table should be refreshable.
If necessary I will submit a file with data.
Thanks
Miguel
See Answer
July 16, 2010
Online
Hi Miguel,
The correct way to approach this is to use Power Query to combine the source data that the two PivotTables are based on, rather than building PivotTables and then getting the data from them.
It's not clear where the source data for the two PivotTables is stored, but if it's in separate sheets in an Excel file, then this tutorial on consolidating Excel sheets with Power Query may help.
Hope that points you in the right direction.
Mynda
May 27, 2014
Offline
Thanks, Mynda, for your help.
There are some conditions that I didn’t express at first hand.
This is for a Real Estate Business:
- For the same Property you can have an Agent that brings the property to sell and another Agent that finds the Buyer or the same Agent for both situations.
- All the information of one business should be in the same row
Attached is a file with all the information.
Thank you for taking the time to resolve the issue.
VIP
Trusted Members
December 7, 2016
Offline
Hello,
Please view attached copy of your sample file. In sheet Table Example I have restructured your data into a tabular formatted table. As I worked in Excel app on an iPad I could not create a pivot table, but you will notice how much easier it is to get the data you want.
Br,
Anders
Answers Post
May 27, 2014
Offline
One Column with all Agents (Buyers and Sellers) the solution.
Thanks Anders
VIP
Trusted Members
December 7, 2016
Offline
Hello,
Thank you for your feedback. This is the way the data should be structured, makes it a lot easier to get wanted data from pivot tables and functions. You can read more in the blog article Excel Tabular Data Format.
Br,
Anders
1 Guest(s)
