1 Reply Latest reply on Jun 6, 2016 6:50 AM by Keith Conner

    Actual vs Budget - another round - Pick 1 and only 1 of each

    Keith Conner

      Hi,

       

      I was searching the Tableau community for Actual vs budget, and I was unable to find a solution to my problem. The closest I came was 'Filtering Multiple Dimensions Using Parameters' at http://kb.tableau.com/articles/knowledgebase/filtering-multiple-dimensions-using-parameters

       

      My problem is I would like to pick one and only one of each. Let me explain using superstore, since my data is in the same structure.  From furniture, you can only pick 1 sub-category (this would be like 'Actual' in my data), and you can only pick 1 from  Technology (this would be like 'Actual' in my data). so my dropdowns for selection would be

       

      Actual- (Bookcases, chairs, furnishings, tables) and Plan (Accessories, Copiers, Machines, Phones).

       

      superstore.JPG

      Again, thank you in advance. The Tableau community is awesome.

       

      Sincerely,

      Keith Conner

      keith.conner@axiscapital.com

      Desk: 678-746-9561