Hi there,
Looking for a way to solve this:
- I have 1 pivot table in which I have data according to my selection of the product ("pear", "apple", etc).
- I have a second Pivot Table that gives me other information on the same selection of product.
I can not combine the 2 pivot Tables because they take data from different lookup tables (one pivot is actually looking at a monthly view, the second one at a yearly view).
However, I would like to know how I could automatically get the data for "apples" in the second pivot when I choose "apples" in the 1st (so that both pivot show data of the same fruit). Currently I have to choose "apple" in the 1st pivot and then manually choose "apples" in the second pivot.
Any idea?
Thanks for help.
Bookmarks