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