2 Replies Latest reply on Apr 21, 2017 3:34 AM by Rahul Kondhalkar

    Equal and Opposite selection

    Rahul Kondhalkar

      Hello,

       

      In Tableau 9.3:

       

      There are different users using  8 products such as A, B, C, D,E,F, G and H  .  We want to create two separate tables on dashboard like

       

      Table1:

      IF we select user(using User filter) and he is using products  A and B then only A & B will  get populated in Table1

       

      Table2 : In the table 2 we will be able to see remaining products (C, D, E,F, G and H) 

       

      We have tried below solution already but as we can’t setup multiple current values while creating a parameter it is not working for us.

       

      1-Create a Parameter    ProductParameter: type string ,   add from field Products

       

      2-Create two sets from  Products

           SelectedProducts:  By Formula :   [Products] = [Products Parameter]

           OtherProducts:  By Formula :   [Products] <> [Products Parameter]

       

      3-Create one sheet with the SelectedProducts set on the Filter shelf  and another with the OtherProducts set

       

      4-Bring the two sheets on the dashboard along with the parameter for the selection

       

       

      Can you please help us on the same.

       

      Thanks you in advance.