Compare 2 pivot tables and if value matches then sum the values and update in table 3

**hai_krk** · 07-07-2018, 12:36 AM

Hi,

I have 2 pivots 1 and 2. I am trying to compare these 2 pivots. If name in pivot 1 matches with name in Pivot 2 then need to sum the corresponding values in table 3 against the name. attached sheet for reference

**indkitty** · 07-07-2018, 02:52 AM

Hi

Refer to the attached sheet for the formula to sum the results from the 2 pivot table.

Cheers
Krishna

Compare 2 pivot tables and if value matches then sum the values and update in table 3

LinkBack

Thread Tools

Rate This Thread

Display

Compare 2 pivot tables and if value matches then sum the values and update in table 3

Re: Compare 2 pivot tables and if value matches then sum the values and update in table 3

Thread Information

Users Browsing this Thread

Similar Threads

Two pivot tables with the filter of pivot table 2 to automatically update to filter 1

Two pivot tables with the filter of pivot table 2 to automatically update to filter 1

Macro to update pivot table filters from multiple pivot tables of different data sources

How to filter Top 10 values on 1 pivot table & reflect filtered items on all pivot tables

VBA to compare master table to subordinate datasheets and update values

Compare two columns for matches and add values into third column based on matches.

Can a Pivot Table automatically compare values to values from a prior date?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions