2 Replies Latest reply on Jul 10, 2018 11:52 PM by Mahfooj Khan

    Group Values Showing Wrong, When Apply Action In Tableau

    Kapil Dks

      Hi,

       

      Could you please anyone help me one this scenario,

       

      I have two sheet in Dashboard,

       

      1st sheet Bar Graph : Product Wise Sales.

       

      In Product Table I have three values follows : A1,A2,B2,C2

       

      I have grouped A1 & A2 to A. Now My Bar Graph shows A,B2,C2 sales.

       

      2nd sheet Table Graph : With detailed information.

       

      Many columns with details. Including "Product Column".

       

      My Question : When am clicking on a "A", in detailed sheet it should show A1,A2's values separately but it is showing A1,A2 both together in each column.

       

      Any solution?

        • 1. Re: Group Values Showing Wrong, When Apply Action In Tableau
          anil saini

          Hi Kapil,

           

          are you using the original product column in your detailed table or the new grouped column?

           

          I am using one sheet as subcategory wise sales, and another as detailed table

          There are two subcategory starts with 'A', So i clubbed them together and named as 'A'

           

          and it works after action filter

           

          Please check which column are you using in your detailed table.

          Or please attach your workbook

          • 2. Re: Group Values Showing Wrong, When Apply Action In Tableau
            Mahfooj Khan

            Hi Kapil,

             

            Correct me if I've misunderstood your requirement.

            Lets assume you've data like this

            Product Sales (Grouped)

            And Product detail , your dashboard action will act properly when you'll put the grouped field in detail shelf

            then create dashboard action using your grouped field like this

            so when you'll select grouped product "A" your action will show only associated product details in your view.

            Let us know if this help.

             

            Mahfooj