Pivot Table Filter Updates

  • 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!

  • Re: Pivot Table Filter Updates


    Quote from Oeldere;664401

    maybe something like this?


    Thanks for the response, not quite what I was looking for though. I already have a pivot table and I would like to know how to modify that to fit my needs. Thanks again!