I have 3 pivot tables, all from same source, where pivot 1 reflects all "occurrences". Pivot 2 shows a subset of pivot 1 "occurrences" that also have any specified "codes". Pivot 3 shows a subset of pivot 2, where it shows only a few of the "codes" from pivot 2.
I'd like to combine some data from each of these pivot tables in a single chart. Do i somehow have to link the 3 pivot tables (e.g. using power pivot, maybe?) in order to do so? I can provide screenshots or sample example of pivots. The attached example is located in TAB7
Solved by O. C. in 21 mins