0 Replies Latest reply: Oct 24, 2013 1:26 AM by Veronica Yao RSS

    Inner Join, Outer Join, and Subtract between pivot tables

      I have 2 pivot tables on 2 different tabs (in my attached file, they are on 'leaf1' and 'leaf2' tab). By selecting a logic box with value 'and', 'or', 'exclude'  on 1st tab ('leaf1'), I want to create a final pivot table on a 3rd tab (referred as 'tree' tab in my file), that shows data by 'inner joining', 'outer joining', 'subtracting leaf1 from leaf2' data between previous 2 pivot tables.

       

      Could I know how to do this?

       

      Thanks