Good Afternoon Everyone-
Had a question that seems as if it should have a simple solution but after an extensive search, no information has come close to answer the question that I have. I have a pivot table that has dollar values with 3+ different filters (customer, item, store...).
Customer A 910 36
Customer B 918 21
Customer C 920 12
If you select customer A, only item 910 and 918 apply and store 36 apply.
Thus, my goal is to select Customer A and have 920 and 21 and 12 no longer an option on the drop down menus associated with item and store...
Any help you could offer would be greatly appreciated!
P.S. Attached I have an example, thanks again!