2 Replies Latest reply on Apr 3, 2018 12:24 AM by Christian Go

    adding column details to worksheet without drilling down view

    Christian Go

      I have 2 tabs attached,

       

      1st tab:

      2nd tab

       

       

      So on the 1st tab, country worksheet drills down on cat worksheet.

      While cat worksheet drills down on the details worksheet on the 2nd tab

       

      The problem is even if only one country is selected in the 1st dashboard:

      If I click on tablet, all countries still appear on details tab, (this should only by US - Tablet):

       

       

      I can try adding country in the details of the cat dashboard but the resulting view is not the one desired:

        • 1. Re: adding column details to worksheet without drilling down view
          Sankarmagesh Rajan

          Hi Chris,

          I have checked workbook and it perfectly filters country details.

          I have added details also in same dashboard and selected us. now details sheet shown Us.

           

           

          If i click tablet then it filters 2nd tab as

          Your workbook works well. Please check again.

           

          Thanks

          sankar

          • 2. Re: adding column details to worksheet without drilling down view
            Christian Go

            Hi Sankar, thanks for checking

             

             

            Sorry didn't made it clear enough, so the action filters on my actual dashboard are

                 1st tab: Country --> 1st tab: Category

                 1st tab: Category --> 2nd tab: Details (The 2nd tab:Details should inherit both the category selection and the country selection from the 1st tab)

             

             

            So what should happen is if we select from the CAT TABLE the [Tablet -1] when US is selected, it should drill down to only one row which is [US - Tablet] and not all [Tablet] data.

             

            Also adding the country in the details of the CAT tab will result in this display [Tablet - 1 1 1 1] same as the screenshot I posted above, I would still like it to have everything totaled when all countries are selected.